Forum Discussion
Solved
Working with multiple excel files as data source
Hi, is there a way to merge all excel files as separate sheets into one file and make a single connect into power bi, currently my queries are connected to single excel file, one query one connection,...
Importing as a folder should work
I have designed a dashboard with multiple csv file as inputs to different queries, now I want to consolidate all excel files into different sheets in one file and make a single connect, is this possible, or how can this be done in power bi desktop, reducing multiple source connections to one
Importing as a folder should work
- Thanks Thomson, will try that