Error loading data - need help!

[alvaro-]

Hi, 

I'm new to this new whole world, and I'm trying to follow market values in a model. I haven't had any problems loading the things from the web and creating my database. But when I try to load those data into my data model, then I keep receiving this message:

DataSource.Error: An unknown error occurred when navigating to the web page.
Detalles:
DataSourceKind=Web
DataSourcePath=https://coinmarketcap.com/currencies/ripple/historical-data
StatusCode=429

Can you help me? Obviously, the url works perfectly

Thanks in advance!

[edhans]

I got it to work by opening Power Query, then selecting New Source, Web, then used "basic" and pasted in that URL. 

It showed me 5 tables to pick from. Table 4 looked the most interesting with a bunch of dates and values. This is the October 2019 desktop app that I used. 

It did error out when I tried to get data from the main Power BI Desktop ribbon.

The M code used is this (for table 4)

let
    Source = Web.BrowserContents("https://coinmarketcap.com/currencies/ripple/historical-data"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".active .text-left"}, {"Column2", ".bottom-margin-1x .text-left + *"}, {"Column3", "TD:nth-child(3)"}, {"Column4", "TD:nth-child(4)"}, {"Column5", "TD:nth-child(5)"}, {"Column6", "TD:nth-child(6)"}, {"Column7", "TD:nth-child(7)"}}, [RowSelector=".active .text-left"]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Open*", type number}, {"Column3", type number}, {"Column4", type number}, {"Column5", type number}, {"Column6", Int64.Type}, {"Column7", Int64.Type}})
in
    #"Changed Type"

[Anonymous]

@alvaro-  Status Code 429 = "Too many requests" - Each site defines what they see as "too many requests". https://coinmarketcap.com/terms/ says "You agree that you will not:.....Make excessive requests for information..."

You need to wait a certain length of time before the site will allow you to make another request. Or they may lock you out. 

Also, their terms state: "To request permission to use any Content other than as expressly permitted in these Terms, please contact legal@coinmarketcap.com."

Hope this helps,

Nathan