Hello,
I'm not sure to really understand the privacy levels of power query
OK there are 3 levels (Private/Organisational/Public), but concretely,
If I use power query to make a SQL request to the DB of my company, and simply use the organisational level, what will be the impact, when I will share the workbook to an external person of my company ?
Is the workbook will be readable ? Does it means that the external person will not be able to open the query in power query ?
Actually, what I don't understand is : If an external person get the wrokbook, in all cases , he will not be able to execute the request, since he is not on the intranet and will not have the right elements to execute the SQL request.
So what is the interest of the privacy settings and how could I use it ? Or can I select power query option 'ignore privacy settings'
Thank you for your help
I'm not sure to really understand the privacy levels of power query
OK there are 3 levels (Private/Organisational/Public), but concretely,
If I use power query to make a SQL request to the DB of my company, and simply use the organisational level, what will be the impact, when I will share the workbook to an external person of my company ?
Is the workbook will be readable ? Does it means that the external person will not be able to open the query in power query ?
Actually, what I don't understand is : If an external person get the wrokbook, in all cases , he will not be able to execute the request, since he is not on the intranet and will not have the right elements to execute the SQL request.
So what is the interest of the privacy settings and how could I use it ? Or can I select power query option 'ignore privacy settings'
Thank you for your help