Forum Discussion
Change Data Source from multiple excel files to one workbook with multiple sheets/tables
I am relatively new to Power Bi after using Tableau for a few years.
I have created a visualization with several different Excel files as the data source. Each excel file contained one worksheet. The Excel files contain different types of information. The creator of the source data has now combined the excel files into one workbook with several worksheets. Each worksheet is also a table.
I have tried to change the data source to the new workbook and I am having very little success. Could someone please point me in the right direction on how to change the data sources.
Thanks in advance for the help.
4 Replies
- lbendlin
Super User
That should be straightforward. How familiar are you with Power Query? Have you ever worked with the Advanced Editor?
I am not familiar with either one, however I am up to the task of learning. I have not found any Youtube videos that cover this exact topic. Can you provide me with either a link to a video or outline the approach I need to take.
