Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
derekli17001
Helper I
Helper I

How to replace Dashboard data source if data source is a folder of excel sheets?

Currently i have a old dashboard with visuals and an outdated datasheet matched to it. I have to update it and normally i would go to "data source settings" to replace it - however currently the newest data source is a bunch of excel sheets inside a folder. So far, i have merged/entered the data as a folder into the dashboard however the visual filters/sources are still selected on the old datasheet. 

 

Is there a way to swap the sources assuming the databoxes/selectors on the right hand side are the exact same name/title? I tried using "data source settings" however, it would only let me select a file instead of a folder. Perhaps a way on query editor?

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Watch this video to see the way to create a single table from all files lying in a folder - Zoho Desk Express - Affordable Help Desk Software for Small Businesses (youtube.com)


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

Watch this video to see the way to create a single table from all files lying in a folder - Zoho Desk Express - Affordable Help Desk Software for Small Businesses (youtube.com)


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Fabric Data Days is here Carousel

Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.