Forum Discussion

pk3130's avatar
pk3130
Regular Visitor
1 year ago
Solved

Power BI dynamic visualizations

We have a predefined list of columns (e.g., Col1 to Col50) from which users can select multiple columns. The report includes 10 table visualizations, and each one should display data from one of the ...
Fabric
power bi
Power BI Service
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.
v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
1 year ago

Hi pk3130,

Thank you for reaching out to the Microsoft fabric community forum.  I reproduced the scenario again, and it worked on my end. I used my sample data and successfully implemented it.

Outcome:


For other tables also you can follow same like this mentioned in the .pbix file. I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
1 year ago

Hi pk3130,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you!