How can I upload several excel files in Desktop via Onedrive

[arvindyadav]

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.

[MFelix]

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

[arvindyadav]

Hi @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.

[MFelix]

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