Forum Discussion
Potential Security risk - while using source parameters in power bi template
Hi Community, amitchandak Idrissshatila parry2k Greg_Deckler Ritaf1983
I am getting a potential security risk warning while I am opening a template which has used source parameters, to dynamically enter the server and database name.
Error Message:
This file used multiple data sources. Information in one data source might be shared with other data sources without your knowledge. Only open this file if you trust the sender.
Do you want to open the file?
Although I am using only one data source that is Amazon redshift, but still the error says use of multiple data sources, this error does not occur when I get only a single table from redshift in direct query mode.
But when I try to get more than one table from redshift, by using source parameters, then this security warning comes and after reading such security warning no one would like to open the file,
I need your support in solving this error, attaching a screenshot also for the refrence.
Thanks & Regards,
Shivam Kathpal
5 Replies
Did you set the data privacy levels for your sources in datasource settings?
Hi christinepayton , thanks for the reply,
Our data source is Amazon redshift, so we check this data privacy levels in Redshift or power bi ?
Regards,Shivam Kathpal
In Power BI - go to datasource settings, then "edit permissions" - it will have a dropdown there that lets you select organizational, public, etc. You will get errors like the above if you're combining different data privacy types. You can also turn off the check for this in Power BI settings under privacy.
