we are using the enterprise power bi gateway.
I know that when we schedule or manully refresh data it goes up thru the gateway and validates the user. My understanding is that at no point does actaul data leave my building.
So where does it store the data after a refesh?
Are you using live connection or you selected "import" when you created your reports? If it is import, data resides in powerbi and to check where it is stored,
click ? on top right hand corner
select about powerbi and in the dialog box it will show where data will be stored.
Again, it all goes back to how you are connecting to your data source, (live connection or Import).
if you haven't published your reports then ofcourse data never left your premise. Just to confirm, you are using powerbi desktop, connecting using direct query (seems like you are using ssas) and never published a report, if that is the case, i don't think it ever left your premise.
Live connection means it always polls the data source and data never get moved or imported in powerbi, in short, yes, it will not leave the building.
Again, i never understood, what data source you are connected with and how you are connected? If you are not publishing your reports, you don't need gateway, not sure why you have gateway in place? Are you planning to publish your report to power bi cloud (app.powerbi.com)
we were hoping to pulish to powerbi only becasue we didn't want to give our end users the power bi desktop app. It would be too confusing for our users.
now it make sense why you need gateway.
- Your data is on-prem
- you developed report using on-prem database using Live Connection
- publish your reports
- share with your team
in above scenario, data will not leave your prem, gateway will work between cloud and on-prem to refresh the data.
yep - problem is sharing the report/dashboards with our users. I don't see any other way than giving them the power bi desktop - which is way too much for them to handle.
I'm looking at changing to use live connection - but I don't see a way to change it without recreating the report/dash.
Firstly, after you publish reports to Power BI Service, you can share reports to other users using the methods that described in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-how-should-i-share-my-dashboard/ .
Secondly, we are not able to change import mode to Live connection mode in Power BI Desktop. You would need to connect to your data source using Live connection mode and recreate reports in Power BI Desktop.
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!