Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

The response is not in a JSON format.

(0) ShareShare
ReportReport
Posted on by 1

I am getting an error with "response is not in a JSON format", while running a flow to export a paginated report from PBI.

Below is an screenshot.

RishabhS_0-1658742130033.png

Here is the output for the error:

RishabhS_1-1658742160096.png

This is how the flow look like.

RishabhS_2-1658742237368.png

 

What am I doing wrong here?

  • ArchitectMadhan Profile Picture
    1,580 on at
    Re: The response is not in a JSON format.

    Hi @RishabhS ,

    In order to export the Power BI paginated report as CSV and upload it to SharePoint document library, Please follow the steps mentioned in the below link.

    https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-automate-paginated-excel-sharepoint-list

    Note: Also please check for the size of the exported CSV, if it is huge then you might face this error

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow