Data Model - references other queries or steps

hmbedford · ‎10-13-2020

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

Alexa_11 · ‎04-25-2024

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