Forum Discussion
raymond
Post Patron
Post PatronWebScraping OLE DB or ODBC Error: [DataSource.Error] We are unable to retrieve the contents of ...
Hi Community, I am attempting of scraping a lot of data from the web. I have a list of URLs from which I automated the scraping process with PowerBI. However I will get errors on a seemingly rand...
Very frustrating error indeed, i came across the same.
Found a solution at last in this thread, which addressed ODBC errors more generally: https://www.cloudfronts.com/blog/power-bi/how-to-solve-ole-db-or-odbc-errors-in-powerbi/
Solution is:
Go to Data Source Settings > Global Permissions,
then select the website you were trying to access
> Clear Permissions
This solved my issue. I have to do it again from time to time, when i change the query in Power Query.