Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a situation where I have a file (File0.csv) connected to ADLS which contains the path of other files that need to be loaded in Power BI.
I have created a custom column that concatenates the fields and creates the complete URL.
File0.csv:
How can I achieve loading other files into Power BI space dynamically by URL using a custom function or power query?
Solved! Go to Solution.
@abhay03,
You can firstly connect to https://xxxxxx.azuredatalakestore.net/webhdfs/v1/data folder using ADLS connector in Power BI Desktop following the guide in this blog, then define a parameter in the code in Advanced Editor of your imported query and replace the folder name with in the URL(https://xxxxxx.azuredatalakestore.net/webhdfs/v1/data) with the parameter , and add custom column to get data from all files, which is described in this similar blog: https://www.mattmasson.com/2014/11/iterating-over-multiple-pages-of-web-data-using-power-query/ .
If you have any questions about the code in Advanced Editor, please post a screenshot about your current status and error message.
Regards,
Lydia
@abhay03,
You can firstly connect to https://xxxxxx.azuredatalakestore.net/webhdfs/v1/data folder using ADLS connector in Power BI Desktop following the guide in this blog, then define a parameter in the code in Advanced Editor of your imported query and replace the folder name with in the URL(https://xxxxxx.azuredatalakestore.net/webhdfs/v1/data) with the parameter , and add custom column to get data from all files, which is described in this similar blog: https://www.mattmasson.com/2014/11/iterating-over-multiple-pages-of-web-data-using-power-query/ .
If you have any questions about the code in Advanced Editor, please post a screenshot about your current status and error message.
Regards,
Lydia
I need some help on making this work for our azure subscription.
When I tried to view a single file in the directory of the ADLS, it does not even show the fields on the csv file
And secondly , the example below shows the capability from a webpage, do you have a more recent example actually using the ADLS structure of files created
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |