News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows The response is not in...

Power Automate - Using Flows

Unanswered

The response is not in a JSON format.

Like (0) Share

Report

Report

Posted on 25 Jul 2022 09:45:31 by RishabhS

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.

Here is the output for the error:

This is how the flow look like.

What am I doing wrong here?

All responses Img

All responses (1)

Answers Img

Answers (0)

ArchitectMadhan 1,580 on 25 Jul 2022 at 10:45:16

Like (1)

Report

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

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 2

#2

David_MA 436 Super User 2025 Season 2

#3

Riyaz_riz11 244 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans