Forum Discussion

RajaniS's avatar
RajaniS
New Member
2 years ago

Power automate instant flow Internal server error

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."
Data Protection
Dataflow
Interesting Links
Show and Tell
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.