Hello, all.
I have created a report in Power BI Desktop that has a live connection to one of my organization’s SQL databases. I have published this report to my workspace in the Power BI Service.
I then published the report as an Embed Report (Website or Portal, NOT public).
I was able to place the <iframe> code within our organization’s portal (login required for access), and the report works great!
However, I have a few questions about data security:
- When I publish the report to the Service, is our data from the SQL database actually copied to the Power BI Service and stored on a Microsoft server. I guess I’m asking if the data from our SQL database is leaving our organization and now lives on a server outside of our control.
- If this is the case, is that presenting a security risk for our organization, and what have others done to preserve the security of their data?
- Is there a way to set this up so the data does not get copied to the Power BI service, if that is indeed what is happening? I have developed some very useful reports that I would like to make available to others by logging in to our organization’s portal, but if the data is at risk, I don’t feel comfortable doing that.
Thank you in advance,
Monte
