Forum Discussion
Power BI dynamic visualizations
Power BI cannot work with encrypted Excel files.
Confidential - Microsoft Extended:DESCRIPTION Data is classified and protected. Microsoft Full Time Employees (FTE) and non-employees can edit, reply, forward and print. Recipient can unprotect content with the right justification.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks lbendlin
As requested here is the file. It has three sheets.
Input1-MainTable : This is the main table which has the customer data of all the columns
input2-UserselectedColumns : This is the table where we will load only the required columns based on the user selection, inshort this table will have columns that are required to show in Visualizations.
Ouput : Exepcted Table Viz
https://docs.google.com/spreadsheets/d/1XgzhaHq1wA1k0X6jEvjWbo-EOzUPCNAH/edit?usp=sharing&ouid=100891880143872369067&rtpof=true&sd=truePower BI cannot work with encrypted Excel files.
Confidential - Microsoft Extended:DESCRIPTION Data is classified and protected. Microsoft Full Time Employees (FTE) and non-employees can edit, reply, forward and print. Recipient can unprotect content with the right justification.