Web Connector

[Kolumam]

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.

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?

[v-cherch-msft]

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