Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Power BI Query Data via Parse JSON (Power Automate)

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2025 08:13:03 by

Hi everyone,

I'm facing an issue where I need to run a Power Automate flow that includes a Power BI query.

The screenshot below shows a part of my flow:

 

 

My question is, has anyone encountered issues with the Parse JSON action? I keep receiving the error message: "Action 'Parse_JSON' failed: The schema validation failed." 

 

I've used the schema generated by Power Automate's "Sample payload to generate schema" feature, but the issue persists. I've also changed the data types in Power Query to ensure all data is in text format.

I would appreciate any insights from the team, as I've been stuck on this issue for quite some time. Thank you 😄

  • lbendlin Profile Picture
    lbendlin 7,572 on 15 Jan 2025 at 00:00:54
    Power BI Query Data via Parse JSON (Power Automate)
    "Refresh a Dataset" is ASYNCHRONOUS!  Your "Run a Query against a Dataset"  will query the non-refreshed version.
     
    There is no need to parse the JSON.  You can directly ingest the body/firsttablerows item into your next step.

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,593

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,403

Leaderboard
Loading started