Forum Discussion
Solved
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 in...
Found the issue, I forgot to publish (upload to the service) the latest version of my report that included said table!
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!