Confidentiality problem in PowerBi service

[Anonymous]

Hi everybody,

I'm new in power BI and I have a problem when I publish my report on Power BI service.

In Power BI desktop, I get 5 tables from a private SQL database.

In one of this table, I add a column by calling a web API to get GPS coordinates from address.

Here the code : 
= Table.ExpandTableColumn(Table.AddColumn(#"Colonne fusionnée insérée", "LatitudeLongitude", each try fxPointLookup(Text.Trim(Text.Replace([Address], "&", " and "))) otherwise
try fxPointLookup(Text.Trim(Text.Replace([City], "&", " and "))) otherwise fxPointLookup(Text.Trim(Text.Replace([COUNTRY], "&", " and "))) ), "LatitudeLongitude", {"Latitude", "Longitude"}, {"Latitude", "Longitude"})

My problem is, ADDRESS contains private data (from private database), and I call an URL, so Power BI set this URL as public. Private and public data can't work together in power bi service :'( (it works in power bi desktop by ignoring confidentiality problem).

Here is problem details in Power BI service : 

Erreur de source de données: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[Impossible de combiner des données] Section1/ADDRESS/Appel de fonction accède à des sources de données dont les niveaux de confidentialité ne peuvent pas être utilisés ensemble. Reconstruisez cette combinaison de données."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"PostgreSQL\",\"path\":\"<ip>5.135.48.147</ip>:54327;ecc\"},{\"kind\":\"Web\",\"path\":\"http://dev.virtualearth.net/REST/v1/Locations/GOSB%20-%20Gebze%20Organize%20Sanayi%20B%C3%B6lgesi%20...\u0026key=Auk701VftF2vNq0fVEBrhvoPR08nJVvUHDQJu5DcTkcJLeqV0I1jPw5o_naSQYih\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacyError"}}],"exceptionCulprit":1}}} Table: ADDRESS.
URI du cluster: WABI-FRANCE-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
ID d'activité: 75a21a01-7488-47ca-81a1-1aa407e6229b
ID de demande: 53643c27-b4fd-0835-2c13-107409ea6920
Heure: 2023-08-10 09:56:04Z

=> How can I call a web service function (public) with some private data ?

[Anonymous]

Hi,

Solution 1 doesn't work because Power BI service ignore the settings of "ignoring confidentialy level". Then, when I set privacy level to private for both, the problems is the same.

Solution 2, I'm searching for another solution. And it seems we need to have GPS coordinates in the original database to avoid a call to an API in Power BI. But it's not easy to do this.

Thanks for your help

[Anonymous]

Hi @Anonymous ,

The error message you received indicates that you are trying to combine data from sources with different privacy levels, which is not allowed by Power BI.

You can try:

1.Change the privacy level of your web service function to match the privacy level of your private SQL database or ignore the privacy levels.

2.Consider using a different method to obtain GPS coordinates, such as importing the data from a separate table or using a different API that doesn't require sending private data.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.