Power BI PRO Refresh Limit with Direct Query

[QC]

Hi team,

I have a dashboard linking to a PBI dataset, if I use a Power Automate flow to push refresh, would that count towards the 8 times a day limit? 

[Anonymous · Accepted solution]

Hi @QC ,

For datasets in DirectQuery mode, Power BI doesn't import data over connections that operate in DirectQuery mode. Instead, the dataset returns results from the underlying data source whenever a report or dashboard queries the dataset. Power BI transforms and forwards the queries to the data source. Because Power BI doesn't import the data, you don't need to run a data refresh.

For datasets in Import mode, Power BI imports the data from the original data sources into the dataset. Power BI report and dashboard queries submitted to the dataset return results from the imported tables and columns. You might consider such a dataset a point-in-time copy. Because Power BI copies the data, you must refresh the dataset to fetch changes from the underlying data sources.

When your datasets in Import mode, for Pro license, There is a limit of eight scheduled refreshes.

For more details, you can read related document:  Data refresh in Power BI - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cassidy]

Yes, here is a similar thread with more documenation

https://community.fabric.microsoft.com/t5/Desktop/limitations-number-of-runs-power-automate/td-p/127...

[QC]

Thanks, I understand Power Automate counts towards limit, but I am wondering if DQ also counts? Technical it is not a datasource by itself, but link to another source.