Power bi data automation | cosmos db

[kichu123]

I have a power bi report which has one main table in the landing page and another table in the drill through page. I am fetching data from cosmos db. I have a table in the main page where I have implemented custom column selection , that is when user makes a coulmn selection from the slicer those Columns will get reflected in the table. I have implemented this using field parameter. Requirement is in case new columns are get added into database in the future that should get automatically reflected here. But in field parameters we have to enter it manually. Is there any other option in which i can implement this feature so that data which is gonna get updated in the near future will show in the slicer as well as the table.

[v-ssriganesh]

Hello @kichu123,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[v-ssriganesh]

Hello @kichu123,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-ssriganesh]

Hi @kichu123,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @MFelix for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[MFelix · Accepted solution]

Hi @kichu123 ,

For this you need to use the dynamic field parameter approach. Check the video below with the explanations. I have implemented this with a Excel spreadsheet but you can get the information in any format so if you get a table in cosmos DB with the column names you can then automate this.

https://www.youtube.com/watch?v=xjBVKLn5fzs