Solved: What's the equivalent of Power BI Data Import Web ...

Mengeltje · ‎10-27-2022

Hi there,

I have an url that retrieves data from an azure environment (blob, very long one). In Power BI Desktop I can enter this url via get data and web (basic) and I see my data appear.
I want to enter this data via this url into a data flow. But I can't figure out which data source to use there. The data sources with name "web" as well as the Azure Blobs data source all ask for credentials.

Thanks for the help!

ImkeF · ‎10-27-2022

Hi @Mengeltje ,
easiest way would be to simply copy the query from Desktop to dataflow.
The equivalent to the ordinary web connector in dataflows is called "Web API", but not sure that this is actually what you need for your azure connection.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎10-27-2022

Hi @Mengeltje ,
easiest way would be to simply copy the query from Desktop to dataflow.
The equivalent to the ordinary web connector in dataflows is called "Web API", but not sure that this is actually what you need for your azure connection.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries