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.
I'm not able to see the hidden sheet which is present in my workbook, I've data which needs to work upon in Hidden sheet but In Power BI we can't see any hidden sheet, Any resolution to get this data from hidden to Power BI?
Solved! Go to Solution.
@Kiran09 wrote:
I'm not able to see the hidden sheet which is present in my workbook, I've data which needs to work upon in Hidden sheet but In Power BI we can't see any hidden sheet, Any resolution to get this data from hidden to Power BI?
Per my test, the hidden sheets are not shown in the navigator UI. As a workaround, in the query editor, you can go back to the source step and drill drill down the hidden sheet.
@Kiran09 wrote:
I'm not able to see the hidden sheet which is present in my workbook, I've data which needs to work upon in Hidden sheet but In Power BI we can't see any hidden sheet, Any resolution to get this data from hidden to Power BI?
Per my test, the hidden sheets are not shown in the navigator UI. As a workaround, in the query editor, you can go back to the source step and drill drill down the hidden sheet.
Hi! It seems to work when the source is only 1 excel, but how to automate this process when the source is a folder with different excel files?
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |