Forum Discussion
Importing Multiple Selected Excel Sheets from multiple workbooks at one time
Hi, Is there an easy way to import multiple sheets from an excel workbook based on what the sheet name contains. For example, I have 3 excel workbooks with similar data in it. All the workbooks ...
As part of your ingestion you need to unpivot the year columns.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523