RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Power BI Quick Tip: the Formula Bar in Power Query

Often you do the transformation in Power Query using the graphical interface, but having the formula bar visible, makes it much easier to understand or change the transformations. In this short blog and video, I’ll explain that. Power Query transformations In Power BI, we use Power Query a lot for transformations, but mostly using the Read more about Power BI Quick Tip: the Formula Bar in Power Query[…]

Dataflow: a remedy slow data sources in Power BI

I have previously explained a number of use cases for dataflows. One really useful case for it is to use dataflow for slow data sources. In this short article and video, I’ll explain how this works. What is a dataflow? Dataflow is a Power Query process that runs in the cloud and stores the result Read more about Dataflow: a remedy slow data sources in Power BI[…]

Streamline Sharing Folder and Email Message using Power Automate ( Part 1, Folder Creation)

Here I will share one of my business case scenario using Power automate, Excel and OneDrive for a conference management that can be apply to all other training class scenarios.we normally want to create a personalized folder for your students in class or for our speakers in a conference so they/we can put or files Read more about Streamline Sharing Folder and Email Message using Power Automate ( Part 1, Folder Creation)[…]

How to modify a linked entity in Power BI dataflows

It is not possible to change a linked entity in a dataflow in Power BI. Linked entities has to be modified only in the dataflow in which they are created. However, sometimes, you need to do a small modification to the linked entity in a chained dataflow. There is a very simple trick, In this Read more about How to modify a linked entity in Power BI dataflows[…]

How to stop your Power BI tenant becoming a dataset swamp?

Self-service BI! This is what Power BI is all about for business users. They can connect to any available data source and start creating their own reports. However, great Power (BI) comes with great responsibility as per Uncle Ben and not sure business users are aware of their responsibilities when it comes to Power BI Read more about How to stop your Power BI tenant becoming a dataset swamp?[…]

How to organize workspaces in a Power BI environment?

The question I often get in my Power BI architecture consulting sessions is that; “How should we organize our workspaces? should we have one workspace with all the reports in it? or multiple? should we split it based on each report? business unit? or something else?” In this article and video, I’ll explain a guide Read more about How to organize workspaces in a Power BI environment?[…]

Writing calculations on a real-time streaming Power BI dataset using DAX measures

In the previous article and video, I explained a method that you can use to have real-time calculations in a Power BI streaming dataset. The calculations done that way are limited though because it is using the Q&A feature of Power BI. If you are after a complex calculation then DAX can definitely help. In Read more about Writing calculations on a real-time streaming Power BI dataset using DAX measures[…]

How to write simple calculations in a Power BI streaming dataset?

If you use a streaming dataset in Power BI, you cannot download the Power BI file, and you cannot open it using Power BI Desktop. This means that you are limited not to use calculations in a streaming dataset. However, there is a small trick which you can use and can be helpful. I will Read more about How to write simple calculations in a Power BI streaming dataset?[…]

Power BI Helper Version 12 (2021) Feature Summary

Happy New Year. We wish this be a year full of happiness and joy for all of you. We are glad to let you know that version 12 of Power BI Helper is now available to download with the below new features; Detecting the storage mode of tables (DirectQuery, Dual, Import) Detecting the connection mode Read more about Power BI Helper Version 12 (2021) Feature Summary[…]

What should be your Salary in 2021 if you work with Power BI?

The Power BI 2021 Salary survey was popular enough to get some interesting results. In this post, I am sharing the result of that survey (which is filled by the public) as a Power BI report. The report gives you an overall idea of how much the minimum, maximum, and average salary should be based Read more about What should be your Salary in 2021 if you work with Power BI?[…]