Import Directly Into Power Query Do not Save File To Desktop

[UncleLewis]

Hi all,

Is it possible to import data directly into power query from XML or other without downloading saving file first?

I am trying to get H8 data from the Federal Reserve Board.
I created a package and I downloaded the csv file and got everything setup in power query to create the data model.

But I would like to make it a bit more automated so I don't have to download a file each time I want to refresh.

Thanks,

-w

[Anonymous]

@UncleLewis 

In your scenario, you can just connect to the public website, then simply refresh would brings you the newest data.

Connect to a webpage from Power BI Desktop - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[ponnusamy]

@UncleLewis :

yes, you can infact, connect to XML source and pull it directly into power query and do all kind of preparation for Data model. Did you try the following?

Get Data -> All -> XML