cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arvindyadav Member
Member

How can I upload several excel files in Desktop via Onedrive

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.

3 REPLIES 3
Super User III
Super User III

Re: How can I upload several excel files in Desktop via Onedrive

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 Felix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




arvindyadav Member
Member

Re: How can I upload several excel files in Desktop via Onedrive

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.

Super User III
Super User III

Re: How can I upload several excel files in Desktop via Onedrive

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 Felix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors