question

DenineGilliam-7158 avatar image
0 Votes"
DenineGilliam-7158 asked emizhang-msft commented

How to build one Power BI dashboard from multiple Excel workbooth WITH different data structures

I have multiple Excel workbooks that are not identical to each other. Each workbook tracks a different set of data by different team members. However, as a team leader, I want the ability to pull their data together and display one dashboard that is segmented into their respective projects/duties.

I saved each Excel workbook file in SharePoint Online hoping to build a query in Power BI to pull that data. It worked for the first workbook file, but when I added other workbooks, I received errors after the 'invoke custom function' feature because the column headers/data structure varied.

So far, I've only come across articles and videos of loading multiple Excel workbooks that have identical data structures. I want to feed each Excel workbook of data from each team member into Power BI and display a one-paged dashboard. Ideally, each team member would update their monthly data into their respective Excel workbook and I can refresh Power BI to generate a report for the current month.

Is this possible?

power-query-not-supportedoffice-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DenineGilliam-7158,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

0 Votes 0 ·

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @DenineGilliam-7158,
I suggest you post this issue to Power BI forum:

https://community.powerbi.com/
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.