Forum Discussion

sebbyp's avatar
sebbyp
Helper III
4 years ago

Online Refresh Fail due to privacy error - Source is a URL API constructed dynamically

Underlying error code: -2147467259
Underlying error message: [Unable to combine data] Section1/50DMA Split Adjusted Values/Sorted Rows references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"Web","path":"https://eodhistoricaldata.com/api/technical/6758.TSE?order=d\u0026fmt=json\u0026from=2005-12-28\u0026function=sma\u0026period=50\u0026splitadjusted_only=1\u0026api_token="}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacyError
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 926c9e96-2851-4544-a3bf-545e58fc06ba
Request ID: 48636483-e6f7-8407-4a84-e222b7b8dd03

 

I have a dynamic URL API constructed in Power BI desktop which works perfectly on desktop but originally it wouldn't refresh online.  I was advised to create a relative path to breakup the URL.  I did this and the desktop version worked fine but online I now have a different error which is retricting me moving forward.  I have been stuck with this issue for a long time now, i do the work around solution that i get advised but then the issue turns into something completely new.  (Where is my stress ball? lol...) 

 

Privacy settings in desktop and online are set public and i am using the basic login credentials.

 

Any help here would be very much appreciated.

 

Seb  
Time: 2022-01-19 09:24:30Z