Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 refresh, how data is flowing into Dashboard/Visuals. suppose if i select a value in slicer then visual would be filtered. Is this data trasferring back into sql db. if NO then how does it work and how can i improve the performance here.

4 REPLIES 4
v-ljerr-msft
Employee
Employee

Hi @Anonymous,



suppose if i select a value in slicer then visual would be filtered. Is this data trasferring back into sql db. if NO then how does it work and how can i improve the performance here.

No, it is not transferring back to your Azure SQL DB.

 

With import mode, after publish or refresh, your data will be pushed into the Power BI Azure backend (Azure DB/Blob Storage) (in the Service), so it will transfer to Power BI Azure backend instead. 

 

Here is an article about Data Import Best Practices in Power BI, could you go to check if it helps in your scenario? Smiley Happy

 

Regards

djnww
Impactful Individual
Impactful Individual

I believe @Anonymous was asking whether the visual would send a request to pull the appropriate data from the SQL DB. If so, then the answer would be 'Yes'.

 

@Anonymous, there is a clear difference between 'Import' and 'Direct Query' with SQL. This article sums them up.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

 

Cheers,
D

 

 

Anonymous
Not applicable

@djnww @v-ljerr-msft .. I am describing again what i want to know. First forget about direct query in my scenario.

 

I am importing my data from Azure SQL DB --> creating some Visuals --> publishing ---> refreshing the data on scheduled time.

 

Now, I am asking how does my dashboards/Visuals showing data on power bi services. Once i select any filter then how does my data is filtering. Is data flowing back to db ( or some where else like in cache). i know it is in-memory but still from where I am getting my data in visuals.

 

so, my actual question is, Can i optimize this behaviour further. Suppose dashboard is published and I select one country --India --> visuals are taking time for showing data against India. Can I optimized this time?? 

 

 

 

 

djnww
Impactful Individual
Impactful Individual

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors