Forum Discussion
XML file refresh from Azure blob
Hello
I have an Azure blob location where new xml files will be loaded everyday in a new folder. My powerbi dashboard is supposed to refresh everyday to fetch these new files and update the dashboard. As of now the path in the advanced editor looks like this.
#"https://myblob blob core windows net/foldernamenew/thisismyxmlfile xml" = Source{[#"Folder Path"="https://myblob.blob.core.windows.net/foldernamenew",Name="2019.09.0.caonvoe101/thisismyxmlfile.xml"]}[Content],
It is referencing only to one file. I would like to update the dashboard with every new XML file that is uploaded into this blob storage. Is this possible?
Please advice how to do this?
Hi Anonymous ,
You could load all files from Azure Blob, then combined them in Power BI desktop, so that each time the new file added into Azure blob folder will be automatically added into desktop.
How to dynamically append files when Folder is in Microsoft Azure Blob?
Regards,
Yuliana Gu
1 Reply
v-yulgu-msftMicrosoft Employee
Hi Anonymous ,
You could load all files from Azure Blob, then combined them in Power BI desktop, so that each time the new file added into Azure blob folder will be automatically added into desktop.
How to dynamically append files when Folder is in Microsoft Azure Blob?
Regards,
Yuliana Gu