Forum Discussion
Error when refreshing
Hi, I want to refresh data from Yahoo finance in scheduled form.
The first days it worked fine, now it constantly give me errors. For example the last one was the following.
Underlying error code: -2147467259
Underlying error message: [Unable to combine data] Section1/Historical prices/Changed Type6 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://query1.finance.yahoo.com/v7/finance/download/DIS?period1=1563494400\u0026period2=1635880605\u0026interval=1d\u0026events=history"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacyError
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID: 897b873e-d486-4cfe-b8da-e9c1e3925761
Request ID: 83d86442-9a6d-4ad5-abf5-707dee0c166e
Time: 2021-11-02 19:18:17Z
Anyone knows what may have happen or any suggestion?
Hi fmachado27
That error could appear when combining data from 2 different tables. Have you tried to change the Privacy settings to "Always ignore Privacy Level Settings"
You could also try this to see if it will work for you
Power Query Errors: Please Rebuild This Data CombinationThe Excelguru Blog
2 Replies
Hi fmachado27
That error could appear when combining data from 2 different tables. Have you tried to change the Privacy settings to "Always ignore Privacy Level Settings"
You could also try this to see if it will work for you
Power Query Errors: Please Rebuild This Data CombinationThe Excelguru Blog
Hi fmachado27 ,
There seems to be a similar solution that you can check to see if it helps you.
Solved: Yahoo finance refresh in PBI Service - Microsoft Power BI Community
Looking forward to your feedback.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
