Forum Discussion
Excel Abfrage einer Webseite und Verarbeitung mit PowerQuery
Ich habe in einer Excelarbeitsmappe (Excel 2019 unter Win 10) Daten von einer Webseite abgerufen und mit einer Powerquery auf eine Datenblatt übertragen. Das hat bis zum 14.08.2024 einwandfrei funktioniert. Nach diesem Datum erhalte ich beim Aufruf dieser Datei die Fehlermeldung "EXCEL - mit einem Gefahrenzeichen (gelbes Dreieck mit schwarzem Rufzeichen)" und die Button "OK" und "Abbrechen". Beide führen zum
Beenden von Excel. Auch die Schaltflächen "Text/CSV", "Aus dem Web" und "Aus Tabellen/Bereich" ebenso wie "Zuletzt verwendete Quellen" und "Dateien mit Hilfe einer vorhandenen Verbindung aufrufen" führen zu der Fehlermeldung. Einmal waren sogar sämtliche Officeanwendungen deaktivier. Danke für deine Hilfe Karl.
I have now found the culprit. For unknown reasons, the Microsoft program “Microsoft -NET Framwork 4.8” was installed on my PC and that was the culprit. After I removed it, my program is running again without any problems.
Thanks again for your advice
mfg/Ludwig
11 Replies
Was ist das fuer eine Webseite? Vielleicht haben die malicious code dabei, welcher den crash verursacht?
Die Daten stammen von der der Webseite https://muenzshop.rlbooe.at/3870_DE-Services-Kundenblatt.htm. Der Test einens Mitarbeiters von Norton mit Norton Power Eraser ergab keinen malicious code.
mfg/Ludwig
let Source = Web.BrowserContents("https://muenzshop.rlbooe.at/3870_DE-Services-Kundenblatt.htm"), #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column2", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column3", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(4), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column4", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(3), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column5", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(3) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(2), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column6", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(3) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(2) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(1)"}}, [RowSelector="TABLE:nth-child(4) > * > TR"]), #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]) in #"Promoted Headers"
Hi Karl_Ludwig ,
You can try the following steps:
Clear the Power Query cache. Go to File > Options > Data Load> Data Cache Management Options and clear the cache.
Try to check and update the latest data source credentials in the data source settings.
If possible, try recreating the data connections from scratch to see if that resolves the issue.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen,
Thank you for your advice. I am currently on holiday and will try them out when I get back and let you know.
Thank you very much.
Ludwig
It is not possible to create a new data query, as the described error message appears immediately
I cannot find the Data Cache Management Options menu in Excel 2019 Pro (see screenshot)
Kind Regards Ludwig
siehe Anhang.
