Latest Topics
PIT Point In Time
Introduction We often have descriptive data in our Power BI models. Data may vary over time and have validity dates. It can become a real headache when creating a data model. What kind of data? A car could change his production plant through time. A car can have...
Management Studio – Faster with multiple select
In SQL Server Management Studio (SSMS for close friends) but also in a multitude of text editors (such as Notepad++ for example), you can make multiple selections. I thought it was something everyone knew, but I realize that I often look like a magician every time I...
SSIS – Create Environment from Packages variables
I created this script to automate some "not funny" tasks with our SSIS Catalog. If you have several SSIS projects configured in project mode (with a...
Pie Chart is bad!
During my presentation at Power Saturday in Paris, I wanted to demonstrate to an already very optimistic public that Power BI is a great tool...
Previous Topics
SSMS – Query Shortcuts : Feel like a superman developer
SSMS Query ShortcutDear BI Developer, I’m pretty sure you would be happy to improve your productivity. If not, you should at least read this article to look like a superman (superwoman) developer.When I start a new mission, the first thing I do is to set up SSMS (SQL...
My discoveries: Useful links and articles regarding Microsoft Data Plaform
My discoveriesI always wanted to start a blog post with my discoveries on the internet. It’s often the case, and I hope you use it a lot, we are searching for information on a search engine. 2 months later (sometime less), we face the same issue! Excepted if you are...
SSIS – Log Execution time
This query helps you to have a better view of your SSIS Packages executions. When you run a "master job / package", you don't clearly see the...
How to create a database in Azure
Look how it's easy to create a database in Azure! 3 Clicks, 5 minutes and you get a database
Power BI – PowerApps – Microsoft Flow: Do more with your data
Example in this tutorial: Analyse and pick up one of your clients, send him by mail to your account manager and ask them to take contact. (Power BI can do the job!)
PowerBI – Bookmarks
Bookmarks are not perfect, I can easily confirm you. But with them, you can build beautiful and rich reports. In this example, I will show you how your users can switch from one visual to another one.
SSIS – Export SSIS Catalog Environments
You need to: Export your SSIS Environments (Variables) Replicate it on your new server Assign these variables to your new project SSIS Catalog is not complex, but we don't really want to spend our time to copy manually our configuration from one server to another one....
Update Power BI Desktop : More information with less visuals ? Let’s use the Tooltip !
*This post is an update to the video about the Tooltip* It can be sometimes very difficult to put all the information we need in only one report page. Maybe I could remove this visual to add this one instead? But then, I won't have the figures for this year. Maybe...
Power BI Desktop: Print in the A4 size
As you know, the August 2018 update of Power BI Desktop grants us the possibility to export in PDF directly from the Desktop. Two clicks and it's done. Great news right? I remember all the steps I had to go through to make it before, it still give me headache... But...
SP_WHO3 – Running Queries (Toolbox)
Display all running queries Source:http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3 Code: [crayon-5dd2eb63215e8859214000/] Another query is available here: https://github.com/amachanic/sp_whoisactive/ More info:...
Learn DAX from examples: Lazy DAX
My colleague Mathieu Ricour and myself are happy to share you another way to learn DAX. In Lazy DAX, you will found: A Power BI Desktop file: https://github.com/arnaudgastelblum/LazySnail/blob/master/LazyDAX.pbix It contains multiple examples based on a simple...
Power BI Desktop – Age Of Empires
Power BI – Create a Measure Group
Power BI (March 2018) – Report Page ToolTip
Power BI – Extract your Power Query M Script
Connect Excel To Power BI Desktop
You created your model with Power BI Desktop and you want to build and export some report with a classic Pivot Table in Excel. This video is for you. Bonus: Export the content of your Power BI File
PowerBI To SSAS Tabular Project
DAX studio is extended with the vertipaq analyzer! Analyze and improve your datamodels now! The must have tool for everyone working with #PowerBI
https://youtu.be/1A7gFFvlRFI
Oh... did you notice the #PowerBIer mug on @patrickdba his desk?
Power BI shows you the data like a time machine. Keep an eye on this article! (PIT - Point In time in Datavault means something to you?) Thank you
@Vitali_Burla
to reshare it
https://lnkd.in/eGnwUJa
Did you already experienced this? Working with smart persons! I really like my team, they gave me the feeling that I'm a super smart guy! #thankyou #Loveyourself
And the only thing I can reply is: <<<<<<<< https://twitter.com/thesqlgrrrl/status/1186261260389761025
Prochain #meetup du @ClubPowerBI à #Nantes le mardi 19 novembre : A5Sys nous présentera comment s'inspirer de la théorie de la #dataviz pour mettre les données en visuels. Inscriptions ici : https://www.meetup.com/fr-FR/Club-Power-BI/events/265837288/
Arnaud GASTELBLUM
Stay Up to Date!!
Join The Newsletter
Follow or Contact Me
I would really enjoy talking to you! LinkedIn and Twitter are definitely a good place for exchange!