RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Day of Year and Day of Quarter – DAX calculations for Power BI

Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI[…]

Power BI Design Tip: Disable the Auto-Detect Relationship

Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data. However, often, this ability to automatically detect a relationship is more troublesome than helping, especially when you deal with tables that are not designed for reporting. In Read more about Power BI Design Tip: Disable the Auto-Detect Relationship[…]

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?[…]