Error when refreshing

[fmachado27]

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?

[v-henryk-mstf]

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.

[GilbertQ · Accepted solution]

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