Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
For example, i have an excel file named as Bank.xlsx. In this file, i have 4 sheets (Sheet1 - Sheet 4) and this file is saved in my company sharepoint. From Powerbi, select sharepoint folder, point to Bank.xlsx.
No. of Installment | Payment Date | Principal Amount | Outstanding | Description | Reference No. | Bank | Currency |
1111 | 1111 | 1111 | 111 | 111 | 111 | 111 | 111 |
The column names for the 4 sheets are the same. However, i cant select 4 sheets at once i can only select one at a time. Any idea to solve this issue?
Solved! Go to Solution.
Hi @Anonymous ,
@amitchandak 's way is very helpful. It is better to combine all the data into one sheet instead of doing it on Power BI which might take many configurations.
Please have a try.
First, import data from excel, then click Transform data.
Delete all steps except Source.
Then remove other columns except data column.
expand the Data column to the underlying structure
This action will combine the data from all sheets into one.
That’s it, all the data from multiple sheets are combined. You might need, however, to clean the data, remove duplicate headers, etc to have a clean combined table as a result.
Now, This can then be selected as a table
I have found a similar post, please have a try to see if it helps you.
https://community.powerbi.com/t5/Desktop/Multiple-worksheets-in-sharepoint-hosted-Excel/td-p/1146093
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
@amitchandak 's way is very helpful. It is better to combine all the data into one sheet instead of doing it on Power BI which might take many configurations.
Please have a try.
First, import data from excel, then click Transform data.
Delete all steps except Source.
Then remove other columns except data column.
expand the Data column to the underlying structure
This action will combine the data from all sheets into one.
That’s it, all the data from multiple sheets are combined. You might need, however, to clean the data, remove duplicate headers, etc to have a clean combined table as a result.
Now, This can then be selected as a table
I have found a similar post, please have a try to see if it helps you.
https://community.powerbi.com/t5/Desktop/Multiple-worksheets-in-sharepoint-hosted-Excel/td-p/1146093
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , refer if this can help
Noted. This means that it is better to combine all the data into one sheet instead of doing it on PowerBI which might take many configurations, right?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
119 | |
106 | |
78 | |
73 | |
52 |
User | Count |
---|---|
145 | |
108 | |
107 | |
90 | |
65 |