Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

Query Power BI Dataset through Power Automate

Dear All,
I've created a flow to query power bi dataset and save the results in Excel sheet, however, it started to fail with error "

Report requested for export is not on dedicated capacity".

I'm using Power BI Pro license, and found the Per Capacity license is at huge cost! ( 10$ Per month for Pro vs ~5800 $ per month for capacity!!)  ,Can you please advise if Permium per user license can help solving this issue or any other one with reasonable cost ?
Also, is there any workaround or using power automate against power bi REST APIs ?
Thank you.

Super User
Super User

It sounds like your report is in a premium workspace. You probably want to move it out of premium mode if you don't have premium capacity. Are you using any premium features at all? You could probably get away with a Pro license if not. You don't need premium to query a dataset with Power Automate. 


Here's workspace settings: 



Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors