Forum Discussion
Data loads in Power Query but OLE DB or ODBC error in Power BI
Hi,
I'm trying to scrap text from a website (https://find.plasticsurgery.org/country/united%20states/?page=1). The website I'm trying to extract data from is arranged like this:
As I want all pages of data, I use the page number in the URL to create a function with the variable name "PageStart":
(PageStart as text)=>
let
Source = Web.BrowserContents("https://find.plasticsurgery.org/country/united%20states/?page="&PageStart&""),
#"Extracted Table From Html" = Html.Table(Source, {{"Phys", "H3 .ignore-click"}, {"Loca", "[itemprop=""address""]"}}, [RowSelector=".resultSet"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Phys", type text}, {"Loca", type text}})
in
#"Changed Type"
I apply a modulo to filter by sets of 12 (there are 12 items per page).
Powerquery editor is able to pull the data into a table
As you can see the preview result is in a table in power query editor. There predicted to be ~8,000 rows of data. Not sure exactly.
I click "close & apply". It will indicate that it has loaded the first ~400 rows but before giving any output it gives this error message
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] We were unable to retrieve the contents of the web page..'
Any help is appreciated!
Best,
Brian
1 Reply
- v-yanjiang-msft
Community Support
Hi pauperdoc ,
According to your description, I used your code to create a query, after I enter 1 in the function, return a table like this:
Haven't found any error, I attach my sample below for your reference, you can download it to see the difference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.