Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Kolumam
Post Prodigy
Post Prodigy

Web Connector

‎10-02-2018 02:45 AM

Hi All,

 

I have a link (which is confidential so I cannot share here). The webpage consists of URL for 20 sites. Inside each of the sites, ther's another URL. When I click on that URL, I have the JSON Data. Is it possible to use "Web connector" to retreive the json data.

Links.JPG

So when I click on Inverter 1, I have the json data inside. How do I retreive the data using Power BI?

 

Can someone please help here as I am new to Power Query/M?

Message 1 of 2
480 Views
0
1 REPLY 1
v-cherch-msft
Microsoft Employee
Microsoft Employee

‎10-02-2018 11:52 PM

Hi @Kolumam

 

Based on my research,it seems there is no better way to do that. Find an article for you and hope it will be helpful.

https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 2
463 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

View All