Data Model - references other queries or steps

[hmbedford]

Hi

I am having challenges with a data model once uploaded into the Service. The desktop works well and refreshes with no issues, but the error message when trying to refresh indicates a privacy issue:

• “references other queries or steps, so it may not directly access a data source. Please rebuild this data combination”

• “type":1,"value":"PrivacyError”

The data model pulls data from an onprem oracle database through a gateway and also an API. The API requires the oracle data to provide shipping and carrier information, which are passed to the API via a function.

I have followed the steps in the below to separate the data sources, still no joy

https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

In the permissions of the desktop, I have set the permissions of the data sources to the same and tried all combinatons (None, Public, private and Organisational) and i keep having the same issue. 

 Does anyone else have any other suggestions?

Here's the full error message

Data source error{"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":"[Unable to combine data] Section1/P44 Shipmet Data/Removed Columns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Web\",\"path\":\"https://eu12.api.project44.com/api/v4/tl/shipments/statuses?carrierIdentifier.type=P44_EU\\u0026carr...}}} Table: P44 Shipmet Data.

Thanks

Hayden

[aranq]

I faced the exact same issue when combining Oracle DB data with an API for a logistics tracking model we use at 

What finally worked for me was:

Making sure both sources were set to "Organizational" in the desktop privacy settings.

Going to Options > Privacy > Always ignore privacy level settings, then republishing the model.

Wrapping the API call inside a separate function, and passing the Oracle value as a parameter (instead of referencing directly inside the API query).

After doing this, the privacy error disappeared and everything refreshed fine in the Service.

Hope this helps – it was a frustrating one to debug!

[aranq]

I faced the exact same issue when combining Oracle DB data with an API for a logistics tracking model we use at

What finally worked for me was:

Making sure both sources were set to "Organizational" in the desktop privacy settings.

Going to Options > Privacy > Always ignore privacy level settings, then republishing the model.

Wrapping the API call inside a separate function, and passing the Oracle value as a parameter (instead of referencing directly inside the API query).

After doing this, the privacy error disappeared and everything refreshed fine in the Service.

Hope this helps – it was a frustrating one to debug!

[Alexa_11]

Hello esteemed forum members,

We would like to inform you about our service, the Container Tracking API, which we offer.

In today's logistics world, shipment tracking holds critical importance. Allowing customers to track their shipments instantly and reliably enhances business processes and increases customer satisfaction.

The Container Tracking API is a simple yet powerful tool that you can integrate into your website. With this API, you can easily view real-time locations, delivery dates, and other essential information by entering shipment numbers or container details.

Our API integrates with systems of various logistics companies, providing extensive coverage. This allows you to track shipments made with different carriers through a single interface. Moreover, we have taken top-level measures for security and privacy, ensuring that customer information is always secure.

If you wish to add a shipment tracking service to your website and provide a better experience for your customers, you can choose our Container Tracking API. Feel free to contact us for detailed information and to try the API. https://shipsgo.com/api-documentation

[v-easonf-msft]

Hi , @hmbedford 

Maybe you just   overlooked the privacy settings in the BI Web Service 
 

You also can check if these related documents help:

https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/ 

https://docs.microsoft.com/en-us/power-query/dataprivacyfirewall

Best Regards,
Community Support Team _ Eason