Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Is there are any possibility to pull many excel files from Onedrive personal and connect with single PBIX file i.e, power bi desktop.
Please help me out I am searching it a month ago.
Regards,
Arvind.
Hi @arvindyadav,
Try to check this link maybe it can guide you on the right diretion, it has a similar request from yours.
Didn't try it myself because I only use onedrive professional.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix,
It is for only one excel files If I want to another excel workbook with the same format how can I upload in Onedrive that fluctuate same in power bi desktop. Meanwhile, I want same Excel file for every day for updating the file. And yes I don't want to replace the previous file I want to add next excel file and it automatic update my data in power bi desktop after refreshing.
Thanks in advance!!!
Regards,
Arvind.
Hi @arvindyadav,
If your files have always the same name with a different date check this link that does o loop through several web pages can work for your purposes.
http://blogs.adatis.co.uk/callumgreen/post/Loop-through-Multiple-Web-Pages-using-Power-Query
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português