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)

Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
Somesh_Bhalerao on at

Like (0)

Report

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