web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Using Connectors
Unanswered

Unauthorized error in "run a query against a dataset" action in power automate

(0) ShareShare
ReportReport
Posted on by

I have created a flow using the "run a query against a dataset" action in power automate to fetch table details from a PowerBI table. It is working perfectly fine for me but when I shared the flow with a colleague it is not working as expected. It is giving unauthorized error at the header level and the below error.

"message": "The response is not in a JSON format.",
      "innerError": "Cannot read server response."

Could anyone help with this?
Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    48,414 Super User 2025 Season 2 on at
    Unauthorized error in "run a query against a dataset" action in power automate
     
    Does the user have a license and what level license do they have? 
     
    Do they have access to the data itself and if so what access level?

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 706 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 508 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 320

Last 30 days Overall leaderboard

Featured topics