Reference from Another Query in Dataflow – No Premium Needed – Power Platform Dataflows

I have previously explained one of the benefits of Power Platform dataflows, which was the ability to refresh the data as many times as you want (on a scheduled basis), and the ability to refresh even with the frequency of a minute. Another useful feature of Power Platform dataflows is the ability to have referenced Read more about Reference from Another Query in Dataflow – No Premium Needed – Power Platform Dataflows[…]

Refresh Power BI Queries Through Power Platform Dataflows: Unlimited Times with Any Frequency

If you don’t have a Power BI Premium capacity license, then you are limited to refresh your dataflows up to eight times a day, with the frequency of 30 minutes. The good news for you is that you have a way to do unlimited refreshes and with whatever frequency you like using Power Platform Dataflows. Read more about Refresh Power BI Queries Through Power Platform Dataflows: Unlimited Times with Any Frequency[…]

Azure Machine Learning Services : Deploy AutoML Model and Use it in Power BI- Part 3

  As I have discussed in part 1 and Part 2, the new possibility of creating machine learning without writing any Python or R codes is so amazing. In Part One, the difference between Azure ML Studio (the traditional one) and the Azure ML Services (new component) has been very briefly explained. (I will write Read more about Azure Machine Learning Services : Deploy AutoML Model and Use it in Power BI- Part 3[…]

Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets

Using Power BI is simple, however, using it properly, needs a good architecture. In a multi-developer tenant, the architecture of a Power BI implementation should allow multiple developers to work on the same solution at the same time. On the other hand, the Power BI architecture should be designed in a way that different layers Read more about Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets[…]

Move Your Shared Tables to Dataflow; Build a Consistent Table in Power BI

I have written previously about the use cases of Dataflow in Power BI, and one of them was using one Power Query table in multiple Power BI reports. However, I that article just covered the surface, and I still see many solutions duplicating Power Query scripts in multiple files which brings a lot of inconsistency Read more about Move Your Shared Tables to Dataflow; Build a Consistent Table in Power BI[…]

How to Use Dataflow to Make the Refresh of Power BI Solution FASTER!

Does it take a long time to get your data refreshed in your Power BI model? Should you wait for hours for the refresh to finish because you have complex transformations behind the scene? Does the long refresh time make it hard for you to develop your solution? The good news I have for you Read more about How to Use Dataflow to Make the Refresh of Power BI Solution FASTER![…]

Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI

I have previously written about What dataflow is and scenarios of using it. I also wrote an article about Computed Entity and the important role of that for performance and data lineage. However, a Computed entity is a premium-only feature. There are sometimes that you don’t really need premium functions of Power BI, and only Read more about Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI[…]

AI in Dataflow, Azure ML Studio Integration with Power BI Services – Part 3

  In the last two parts, first how we able to use cognitive service in Power BI service (Data flow) has been explained. Then in the second one, the process of using a Pre-built machine learning model for prediction ( classification, regression, and forecasting) has been explained. In this post, I am going to show Read more about AI in Dataflow, Azure ML Studio Integration with Power BI Services – Part 3[…]

AI in Dataflow, Power BI Service, Auto Azure ML – Part2

In the last post, the process of using Cognitive services Text analytics has been presented.   In this post, I will show how to user pre-built AI using some predefined machine learning algorithms in Power BI Service in Data flow. I will follow the same example I show in the Azure ML Studio and Power Read more about AI in Dataflow, Power BI Service, Auto Azure ML – Part2[…]

Linked Entities and Computed Entities; Dataflows in Power BI Part 4

In previous articles, I explained what is the Dataflow and where to use it, I also explained how to create a dataflow, and what is the common data model. In this article, I’m explaining one of the differences between Dataflow and the Power Query in Power BI Desktop, which is Linked Entities and Computed Entities. Read more about Linked Entities and Computed Entities; Dataflows in Power BI Part 4[…]