Updating my existing queries with new columns in Datasource

[Henryahern]

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)

[v-yuta-msft]

Hi Henryahern,

Have you solved your issue? 

Regards,

JImmy Tao

[v-yuta-msft]

Hi Henryahern,

Are you connecting to cosmos databased use SQL statement to achieve data from june? How are the addition columns be added to the table?

In addtion, you said" When I refresh 'User-session', it only refreshes the data that was in the query from June. "  Could you clarify more details or screenshots about it?

Regards,

Jimmy Tao