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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
derekli17001
Frequent Visitor

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.