Forum Discussion
How to select the csv file by embed link from Power BI service
In the Azure Blob Storage, AI engine has generated multiple csv file (Like - 001.csv, 002.csv, 003.csv .....). File format of the csv is same.
Is there any way to select the csv file by embed link from Power BI service so that it can generate the visualization from power BI according to csv file?
Please give me a suggestion how to solve it?
6 Replies
- lbendlin
Super User
Not sure what you are asking for. You can use Power Query to combine the CSV files.
Suppose, A web application where multiple customers will operate this. Here, I want to embed the link to generate the visualization from power BI. Data source files depend on customers but visualization will be the same. Data source file storage in Azure Blob Storage (Like - 001.csv, 002.csv, 003.csv ....).
For the first time. it's okay to use Power Query to combine the CSV files. But every time data is added in Azure Blob Storage. So, I want to skip the process to combine the CSV files every time. Is there any way it will automatically add(CSV files ) into power query and make visualization according to data of the CSV file. Then it will generate a new embed link.- lbendlin
Yes, you can point Power Query to a folder full of CSV files and combine them into a data source without needing to know the csv file names.
