cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sanjana_R
Helper I
Helper I

run a query against dataset : "code":"DatasetExecuteQueries_DatasetNotAllowed","pbi.error"


I have created below flow which runs a query against a powerbi dataset and im getting error while running it. can anyone help

Sanjana_R_0-1659427506476.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

@ajb034322 
yes i did find a reason for such failure, i changed live connection to import mode, Flow was sucessfull
Datasets - Execute Queries In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Sanjana_R_0-1661519384321.png

 

View solution in original post

2 REPLIES 2
ajb034322
New Member

I am also getting this same issue; I think it is due to querying against an OLAP cube. Did you find a solution to this in the end? 

@ajb034322 
yes i did find a reason for such failure, i changed live connection to import mode, Flow was sucessfull
Datasets - Execute Queries In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Sanjana_R_0-1661519384321.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,168)