- I graduated in finance and control and have several years of work experience in this field. On the search for a new challenge I came across my passion "data in combination with power platform from Microsoft". I find joy in advising companys on how to structure their data and how to visualize that data in powerfull dashboards.
Content
There is a data model. This data model consists of one (1) dimension table and three (3) fact tables. Each fact table consists of one (1) column with the dimension values next to it with a calculation column with revenue, costs, discount.
For each fact table, the revenue, costs and discount must be calculated separately. This can be done by creating a measure nine (9) times. This is not efficient. Certainly not if the model does not consist of three (3) fact tables, but, for example, nine (9). With nine (9) fact tables, eighteen (18) measures will have to be created. Using Tabular Editor 3 – DAX scripting can do this much more efficiently…
There are many third-party tools available for the usage of Power BI. The most commonly used are Tabular Editor, Dax Studio, ALM Toolkit. In this article each of these tools will be explained in detail.
The purpose of this article is to inform and instruct the reader on how to use third-party tools.
A beautiful dashboard has been created, but according to the end user of the dashboard, the data is incorrect. The cause is not clear. It can be due to several factors; or the data itself, the different parts of the Power BI dashboard , an external factor such as a page filter, a wrongly chosen visualization, an error in the calculation, an incorrect data model or a wrong step in the M-Query.
Let me assist with a step by step plan …
If you use an ALL function on a column that has a sorting by column applied, you also need to take that sorting column into account.
With Dax Studio DMV you can easily retrieve and extract information about your Power BI model.
For example:
If you want an extraction of all your measures? Open DAX Studio and at the tab DMV click on TMSCHEMA_MEASURES. Run the SQL select statement…
DAX Studio will then give you an overview of all your measures. Including expressions, format string etc.…
Tip! Change the output option from Grid to Excel Static to export it straight to Excel for further analysis.
You have probably heard about the phrase “gateway”. But what is meant by this phrase?
In an easy explanation: a gateway is a (data) bridge between an on-premise data source and a Microsoft cloud service. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. An one-premise data source can be a source on a hard-drive or a SQL server containing data and running on-premise*, so not cloud based.
You can format all your DAX measures at once. No more single-handed formatting every measure one by one.
To format all your measures at once you will need Tabular Editor 2 (free).
You can then run the c# script:
Model.AllMeasures.FormatDax();
Wanted to bring your row-level security to the next level?
Are u looking for a more dynamic and efficient way to set up your row-level security?
Have a look at my blog “bring your row-level security to the next level” and I help you with that…
Power BI desktop has a lot of keyboard shortcuts. This can make your life so much easier when you are developing on a Power BI Report.
I myself always use Ctrl + Shift + L (select all occurrences of current selection in a DAX measure).
But there are so much more shortcuts which could help you be as efficient as a monkey eating a banana.
When using Power BI Desktop, you can press Shift + ? to show keyboard shortcuts.
Do you want to change the fields in your table visual or matrix visual by slicer selection?
Did you know you can use the option field parameters for this. Field parameters gives you the option to choose your fields by slicer selection.
Sharepoint.Contents is faster then Sharepoint.Folder. This is because Sharepoint.Contents does not load all the unnecessary folder metadata.
Sharepoint.Contents does require a special M query code + 2 parameters (sharepoint / sourcefolder).
Power BI is secretly hiding a treasure full of data? With DAX Studio (DMV) and the Power BI pbix. desktop file you can find all the Power BI data that was needed to create your power bi model & reports.
This will give you all the insights that you need to maintain en control your power bi environments in even a better way then before.
Power Bi service provides sample datasets? These datasets are perfect if you want to try out Power Bi, but don’t have sufficient data yet.
Just go the power bi service. Click on learn and download your preferred dataset.
A custom date table could be very handy in Power Bi? The build in power bi date table does not always do what is needs to do. Therefore a power query date table could be way more useful.
You can export your power bi report from service to power point. After adding animations and maybe a nice sound you can then export your powerpoint straight into a video or animated GIF. No more screen recording necesarry.
This is how I made the gifs and videos on this blog.