"The response is not in a JSON format." error:trying to convert xlsx to pdf By power automate button

[aditiroy1710]

Hello

While i am trying to convert xlsx  to pdf format by Power automate visuals through power bi, 

I am getting error  like "The response is not in a JSON format."

Flow image:

 

Can you please help me on it?

Thanks in advance

Aditi

[Anonymous]

HI @aditiroy1710,

What type of contents are stored in the file that you used to transform? Are there any data connections to get data from external data sources in your excel sheet? Please share some more detail to help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

In addition, you can also take a look at the following blog about using power automate to convert excel to pdf if helps:

How to convert and save Excel to PDF in Power Automate Flow and Azure Logic Apps — Plumsail Document...

Regards,

Xiaoxin Sheng

[aditiroy1710]

Hi Xiaoxin
No it just an excel file, located in a share point

Test_new. xlsx:  columns:

After converting, a pdf will be created in  a sharepoint location:

Here I get this error:

I go through your link, But couldn't find this on flow:

But here I have found:

But this looks little bit unknown to me:

[Anonymous]

HI @aditiroy1710,

As the error message mentions, it seems like the request is not valid JSON format strings. Have you tried to put them into the JSON formatter to verify the data formats?

In addition, are any specific characters included in the values? (e.g. escape character, Unicode characters) They may also cause issues.
Regards,

Xiaoxin Sheng