Yue Lyu on 18 Nov 2022 05:15:59
1) From PBI Desktop, hide the table using "Hide in report view"
2) Uploads the pbix to PBI Service with the hidden table
3) In PBI Service, download the "Analyze in Excel" file from the dataset that was uploaded with the hidden table
4) Once open the downloaded the "Analyze in Excel" file, the hidden table names could be seen in PivotTable "Show fields" dropdown
*Data does not show up, only table names
It would be great if the table names could also be hidden while using "Analyze in Excel".