Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

0

Direct Query

Submitted by Anonymous on ‎12-13-2022 07:46 AM

Hi everyone,

I am working in a proyect in which the data source is Cosmos DB and we use a Synapse link to obtain real time connection using Direct Query. The problem is that we are forced to used calculated tables in order to obtained the visualizations needed. Is there anyway to refresh these calculated tables automatically every time the table which comes from Direct Query changes?

 

Thank you,

My email is salinass1109@gmail.com

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎12-13-2022 06:55 PM

Hi @Anonymous 

Calculated tables are recalculated if any of the tables they pull data from are refreshed or updated, unless the table uses data from a table that uses DirectQuery; in the case with DirectQuery, the table will only reflect the changes once the dataset has been refreshed. If a table needs to use DirectQuery, it's best to have the calculated table in DirectQuery as well.

 

Calculated tables are always imported, and their data is refreshed when you refresh the tables. If a calculated table refers to a DirectQuery table, visuals that refer to the DirectQuery table always show the latest values in the underlying source. Alternatively, visuals that refer to the calculated table show the values at the time when the calculated table was last refreshed .

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses