Refresh live connection (why)??

[nicolajb]

Hi,

I'm having a hard time understanding the logic of the refresh functionality.

I use the gateway to connect live to both Tabular and Multidimensional cubes. 

Even though these connections are live I have the option of clicking "Refresh Now" on a dataset using one of these connections.

When i click refresh different things happens for the two type of connections....

For the Tabular connection I can se the "On Demand" refresh in the refresh history

For the multidimensional connection nothing shows up in the history.

How does this refresh work.... and why does it even exist for live connections?

Thanx

Nicolaj

[ankitpatira · Accepted solution]

@nicolajb I have noticed even when DirectQuery feature I see Refresh Now option and my understanding of it is that Refresh Now will also include any metadata changes that you have ie added or removed columns. With DirectQuery you connect live but you don't update metadata changes.

[nicolajb]

@ankitpatira, that makes perfect sense! Thanx a lot 🙂