Dear all,
I am trying to use Power BI desktop to connect to SharePoint Online lists and create and publish reports to the Power BI service using the desktop app. I have some questions pertaining to security -
1. When I connect to a SharePoint list, I do so using my company Azure ID + MFA and then select list(s) to import to Power BI and create reports. When I do this -
a. Is data persisted to Power BI desktop or is it just fetched over the network as needed?
b. How is any data persisted to Power BI secured at rest?
c. When I restart my machine and launch power BI desktop to again work on the report, will I be asked to authenticate into SharePoint online again? Or will Power BI just work on the local copy of the data?
d. How will PowerBI know if something has changed on the SharePoint list and an update is needed?
e. I am assuming that the data in transit between PowerBI desktop and the PowerBI service is secured, using TLS 1.2 or above? Is that correct?
Could someone with the experience/knowledge on this explain. Thanks.
Regards,
Raunak
