The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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
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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
42 | |
24 | |
23 | |
22 |