topic Import json file using power bi api in Developer

Import json file using power bi api

Anonymous — Thu, 23 Sep 2021 05:21:20 GMT

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 ?

lbendlin — Sun, 26 Sep 2021 02:45:27 GMT

@Anonymous try it in the API sandbox

Click the "Try it" button.

Anonymous — Mon, 27 Sep 2021 09:29:51 GMT

Hi @Anonymous

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

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

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.

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.