Power automate instant flow Internal server error

[RajaniS]

We developed a Power automate instant flow for email automation. The data will be taken from power BI service using " Run a query against a dataset" action. It has been working fine. But when user tried run the flow it thrown below error. 

I have given Power BI Dataset access with all permissions for user and  Run only user access to the Power Automate flow. 

Does user needs Power automate flow liscence to run it or workspace acess to get dataset access?

"message": "The response is not in a JSON format.",

    "innerError": "Cannot read server response."

[Anonymous]

Hi, @RajaniS 

It's possible that the data returned by the Power BI service isn't in the expected JSON format, which could be due to an incorrectly configured query or an issue with the dataset itself. Check your data format to make sure that the data returned by your dataset is in JSON format, if not, you may need to add an extra step in the Power Automate flow to convert the data format.

Verify the permissions to confirm that the user not only has access to the Power BI dataset, but also to the workspace.

It may be a transient issue with the Power BI service or Power Automate, check the service status of Power BI and Power Automate to confirm that there are no reported issues or maintenance activities.

Try reauthorizing the Power Automate flow to access the Power BI dataset.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.