Forum Discussion
Mikelytics
Resident Rockstar
Resident RockstarGet Table Object based on String
Dear community, following topic. Lets say I have 3 different tables (dummy data only, the original table have multiple columns and more rows): Furthermore, I have...
Hi Mikelytics ,
you could use the function Expression.Evaluate for it, but this won't work if you want to refresh the report in the PBI service.
Instead, I would recommend to append all 3 tables into 1 and create a "TableName" column to distinguish between them. Then you can use a Table.SelectRows command to filter the relevant table for each row, as this allows you to pass a text string.
ImkeF
Community Champion
Community ChampionHi AntrikshSharma ,
it's been a while since I last played with #section and #shared, but to my experience they will not work once you try to load in the datamodel or in the service.
So I am very interested to hear if your query will actually load into the datamodel without causing errors nowadays.