Hi, I am hoping somebody can help me out. Apologies, if this is a very stupid question and I am missing something completely obvious but here it goes anyway.
I am connected into a cosmos.db as my data source and have a number of queries loaded into my PowerBI dashboard.
The source data is continually being udpated release by release as you might expect.
When I refresh the data it only refreshes my existing data.
If I try to edit data from the data source it treats the latest version of the existing query as a new query completely seperate.
For example:
I have a query called 'user-session' in PowerBI since June.
The 'User-session' collection in cosmos DB has had several other columns added that I need in PowerBI for my reports and visulisations.
When I refresh 'User-session', it only refreshes the data that was in the query from June.
When I load/edit from the data source.... it loads as 'User-session'(2).
Is there any way around this other than loading what would become 'User-session'(2) and redoing all the new measures and transformations I did on the original collection? Then Deleting the original and renaming 'User-session'(2)
