cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sowmyas
Frequent Visitor

Import json file using power bi api

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 ?

 

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @sowmyas 

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.

View solution in original post

2 REPLIES 2
RicoZhou
Community Support
Community Support

Hi @sowmyas 

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.

View solution in original post

lbendlin
Super User
Super User

@sowmyas 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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.