Import json file using power bi api

[Anonymous]

Am not able to import json file using PostImportWithFileInGroup api call. Is there any way to upload json file to power bi using power bi api ?

[Anonymous · Accepted solution]

Hi @Anonymous 

Try this way referring from this post: How to get data from REST API (JSON) in Power BI?

You need to use Power Query and Web.Contents connector.

Select:   New Source - Blank Query and in the source window enter:

   " = Json.Document(Web.Contents("https://amshowa.leading2lean.com/api/1.0/billofmaterials/?   

           auth=xxxxxxt&site=1&limit=2000&active=True"))"  (your own API)

And you can refer to this post for more details about how to use a REST API as a data source.

For reference: Using a REST API as a data source

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

@Anonymous try it in the API sandbox

Imports - Post Import In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Click the "Try it"  button.