Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Responsive Resident
Responsive Resident

Get data via Power BI Desktop from excel/csv download link

On numerous times I've used Download links for Excel/csv files to automatically import data from a website that hosts excel files with great results.


However, sometimes the URL is hidden. Either way you can get the URL with some tricks using your Chrome/Edge/Firefox browser.


I managed to extract this URL:


If you click on the link you'll get a 5MB downloaded file or at leaste you're prompted for download. The file works 


If I open PBI Desktop - > Get Data -> Web and paste the URL in there then I was assuming it would work but instead I get scrambled data. Like so:




It doesn't matter what format I choose, none of them return readable data.

Is there some trick I haven't figured out yet and is out there?


You can easily open this 

Not applicable

Why don't you use the exported file as data source instead? 

Save it somewhere on the cloud and you could either use the Excel/CSV connectors or the web link of the file (not the one from your post) with the Web connector?

Because I want to be able to automatically refresh the data straight from the source. Unless I'm missing something that you know about?

Not applicable

Got it, that makes sense. I'm assuming it looks that way since the URL is meant for extraction & conversion. Can you share a picture of how you get that URL? I couldn't navigate easily on the web page as it is in other language. 

Download the file from (top right corner) and press CTRL+J for downloads. Right click and copy URL path from there

Not applicable

I see, file is pushed via JSON which makes it a little bit more complicated to access. One workaround is to create an scheduled workflow in Power Automate to download everyday this file and upload it somewhere in the cloud, then use this file as data source. 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors