Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

how does import work after data refresh

How does import work after data refresh at PBI Services.   I have some Visuals and Slicer, using Azure SQL DB and data is refreshing by using PBI gateway ent.   just want to know after data refre...
djnww's avatar
djnww
Impactful Individual
9 years ago

Hi Anonymous,

 

There are 2 ways to connect your desktop file to SQL. Only DirectQuery allows your PowerBI Online to be refreshed automatically.

 

DirectQuery means that processing is done on your SQL server environment. It only grabs what is required. Yes, this is the most efficient method, but it may chew up resources if your database is being used for other purposes.

 

Cheers,

D