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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Coffee123
New Member

Run a query against a dataset Error - Cannot find table

Hello!

 

Trying to run a dax query in power Automate but I keep getting an error. The dax query was copied from PBI's Performance Analyzer and it rund ok on DAX Studio. But when I paste the code into the Power Automate action I get the following error:

 

{"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"Query (13, 52) Cannot find table 'ClientsAll'."}},

 

Coffee123_0-1676590985285.png

 

I know the table exists, the name hasn't changed, it's in the model, and is properly connected to the proper fact tables. Is there some other reason (a limitation of some sorts) that will not allow a query to run in Power Automate although the query runs ok in DAX Studio? Any help will be appreciated!

1 ACCEPTED SOLUTION
Coffee123
New Member

Found the issue, I forgot to publish (upload to the service) the latest version of my report that included said table!

View solution in original post

6 REPLIES 6
Louis1911
Regular Visitor

I had the exact same problem and just wanted to say the solution solved it for me as well.

I won't be making that mistake again! 😄 Thanks for sharing!

Susan513
Helper II
Helper II

This happened to me today. I made a copy of an existing data flow to run on a copy of the report. I forgot to update the dataset to the new report copy. Duh! I always make copies because - life happens, but forgot I was in a different report. This post helped me figure it out thanks

Coffee123
New Member

Found the issue, I forgot to publish (upload to the service) the latest version of my report that included said table!

Hi! I'm having the same issue! Could you explain in more detail what you mean about uploading the latest version of the report. I'm working on updating the report in the Power BI desktop app. Do I need to publish the report to Power BI cloud for Power Automate to work?

Yes, that is correct! Power Automate can only communicate with the PowerBI report you have published to the service (the cloud). So if you make a change in the PowerBI desktop and create a query using the updated information on PowerBi Desktop, Power Automate won't be able to use it unless you publish the new/updated report to the service first.

Oh my goodness! I spent way too long trying to fix it in the desktop app. But now I know! Thank you so much!

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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