Category: Power Query

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

Posted on by Reza Rad

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

Change Excel Source in Power BI to OneDrive for Business – No Gateway Needed

Posted on by Reza Rad

If you used an excel file in a local source (or even OneDrive for Business, but sourced locally), you need to do one extra step to make your query refreshable without the need to the gateway. Here in this blog post, I’ll explain an easy way to do that change. If you want to learn Read more about Change Excel Source in Power BI to OneDrive for Business – No Gateway Needed[…]

Form Processing Workflow with AI Builder- Data Transformation with Power BI- Part 3

Posted on by Leila Etaati

In the last two posts, I have explained how to use AI Builder with Microsoft Automate (Flow), to do the form processing. In the first post, how to set up AI Builder has been explained, next in the second one how to use Power Automate to detect the fields in a form has been shown. Read more about Form Processing Workflow with AI Builder- Data Transformation with Power BI- Part 3[…]

Time Series Anomaly Detection in Power BI using Cognitive Service and Power Query

Posted on by Leila Etaati

I am excited about this blog post, this is based on the New service in Cognitive Service name “Anomaly Detection” which is now in Preview. I recorded a video about how it works in cognitive service https://youtu.be/7ZOtZDbn6gM.  However, I am going to talk about how to use it in Power BI. In this post first, a Read more about Time Series Anomaly Detection in Power BI using Cognitive Service and Power Query[…]

Pre Concatenate List of Values in Power BI using Power Query

Posted on by Reza Rad

You can concatenate a list of values in Power BI in two ways; Using Power BI DAX functions such as ConcatenateX, or through Power Query. For some scenarios, there is an advantage in using Power Query to do the concatenation. In this blog article, I’ll explain how this works. If you like to learn more Read more about Pre Concatenate List of Values in Power BI using Power Query[…]

Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases

Posted on by Reza Rad

I have written about both types of parameters in Power BI; Power Query parameters and also the What If parameters. However, still many people are not aware that these two are different, and serve different purposes. In this blog article, I am explaining the differences between these two types of parameters, as well as the Read more about Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases[…]

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters

Posted on by Reza Rad

Parameters in Power Query are useful for many scenarios when you want to do something dynamic in the data transformation process. I have previously explained how helpful they are in creating a custom function. In this article, I am showing you another useful way of using Parameters to create dynamic datasets, that you can change Read more about Change the Source of Power BI Datasets Dynamically Using Power Query Parameters[…]

Get The Error Count with the Profiling Data of Power BI Data Table using Power Query

Posted on by Reza Rad

I have explained previously how you can use the Table.Profile Power Query function to fetch the profiling data of a table, such as minimum value, maximum value, null count etc, and use it in a report page to inform the user about the quality of the data. However, that function doesn’t provide you with one Read more about Get The Error Count with the Profiling Data of Power BI Data Table using Power Query[…]

Overview of Available AI and ML capabilities in Power BI

Posted on by Leila Etaati

  There are always many questions about a cheat sheet to shows the existing capability for doing AI and ML in Power BI service and Desktop. In the above chart, I have summarized the capability of doing AI and ML in Power Service and Desktop for each role. I have identified three main roles in Read more about Overview of Available AI and ML capabilities in Power BI[…]

Change the T-SQL Script of a Power BI Table without Add/Remove from the Model

Posted on by Reza Rad

If you have been using T-SQL queries to build the tables of your Power BI data model, you probably know what I’m talking about. Sometimes after a while using a query in the Power BI model, you might change the script and want the change to be applied in the data model. One of the Read more about Change the T-SQL Script of a Power BI Table without Add/Remove from the Model[…]