cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mittalpatel130 Frequent Visitor
Frequent Visitor

On Publish-Where does data store in case of Cloud Service vs PBI RS? Also Import vs DirectQuery?

Hello,

 

I am working on one project of Power BI Deployment. I have questions around where does data store when user publish reports using Power BI Desktop?

 

Where does data stay when publish to Power BI Cloud Service?

Where does data stay when publish to Power BI Report Server?

Where does data stay when publish to Power BI Cloud Service with Import only mode? 

Where does data stay when publish to Power BI Cloud Service with DirectQuery mode?

 Where does data stay when publish to Power BI Report Server with Import only mode? 

Where does data stay when publish to Power BI Report Server with DirectQuery mode? 

 

Please help me understand the difference.

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: On Publish-Where does data store in case of Cloud Service vs PBI RS? Also Import vs DirectQuery?

@mittalpatel130 The short answer is that if you use "Import" -> You will send data to the cloud. If you use "Direct Query, or Live Connection" the data will stay in the source and not be pushed to the cloud.

 

The long version, I wrote 4 blogs covering all these in depth, you can check them out here:

https://powerbi.tips/?s=connection

 

Near SE WI? Join our PUG MSBIWI
3 REPLIES 3
Super User
Super User

Re: On Publish-Where does data store in case of Cloud Service vs PBI RS? Also Import vs DirectQuery?

@mittalpatel130

I am working on one project of Power BI Deployment. I have questions around where does data store when user publish reports using Power BI Desktop? Depends on your connection type

 

Where does data stay when publish to Power BI Cloud Service? Depends on your connection type

Where does data stay when publish to Power BI Report Server? On Premises

Where does data stay when publish to Power BI Cloud Service with Import only mode?  Pushed to the Cloud (Azure backend of Power BI)

Where does data stay when publish to Power BI Cloud Service with DirectQuery mode? Data stays in location of DB

 Where does data stay when publish to Power BI Report Server with Import only mode? On Premises

Where does data stay when publish to Power BI Report Server with DirectQuery mode? Data stays in location of DB

 

Check out the security whitepaper, it addresses all the Could Service component of data handling. here

Near SE WI? Join our PUG MSBIWI
mittalpatel130 Frequent Visitor
Frequent Visitor

Re: On Publish-Where does data store in case of Cloud Service vs PBI RS? Also Import vs DirectQuery?

@Seth_C_Bauer  - Thank you for your response.

 

I have gone through the URL you shared and still I am unclear on which connection type I should implement to restrict data to be sent to Cloud. 

 

Can you please brief me about which connection type you suggested for first 2 questions? 

 

Thank you

Highlighted
Super User
Super User

Re: On Publish-Where does data store in case of Cloud Service vs PBI RS? Also Import vs DirectQuery?

@mittalpatel130 The short answer is that if you use "Import" -> You will send data to the cloud. If you use "Direct Query, or Live Connection" the data will stay in the source and not be pushed to the cloud.

 

The long version, I wrote 4 blogs covering all these in depth, you can check them out here:

https://powerbi.tips/?s=connection

 

Near SE WI? Join our PUG MSBIWI