Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
Solved! Go to 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.
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.
@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.
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |