Answered

The response is not in a JSON format - Running a query against a dataset

(0) Share

Report

Posted on by SRobbo1990

Hi all,

Very very new to Power Automate. I've got a PowerBI report that I've set up with a power automate flow that takes a table and dumps it into a CSV adds a column from our dataset and then saves it to Sharepoint. Had some issues with 'Run only users' but have fixed that. Now unfortunately i'm getting an error I wasn't getting before which is the above. Anyone have any idea how to fix? (Screenshots below);

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!

It looks like an authentication/authorization error - don't have access to the dataset. Can you confirm that the account running the flow has the appropriate access?

Was this reply helpful? Yes No
SRobbo1990 5 on at

Like (1)

Report
Copy link

Link copied!

Yes can confirm that's what the issue was.
Thanks

Was this reply helpful? Yes No
Somesh_Bhalerao on at

Like (0)

Report
Copy link

Link copied!

I have the same issue. I have full access; I can run query in DAX editor however in power automate it give error.

Was this reply helpful? Yes No