Forum Discussion

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

First, go to Edit queries->data source setting, clear or edit this data source credential, select "Basic" from the window and type your username and password.

Then selecting the Extract table using examples presents an interactive window where you can preview the content of the Web page, and enter sample values of the data you would like to extract.

https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example#using-get-data-from-web-by-example

 

Best Regards,
Lin

  • Usman's avatar
    Usman
    Frequent Visitor
    7 years ago

    I'm getting this error after doing what you said.

    DataSource.Error: Web.BrowserContents currently supports only anonymous credentials.
Details:
    DataSourceKind=Web
    DataSourcePath=https://simplywall.st/login
    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      7 years ago

      I was trying to do the same on a website with credentials to no avail. I eventually gave up trying with Power BI. I succeeded using Excel and VBA (I haven't a clue about VBA, but Google is your friend for these things...). 

      It is a real pain, since it involves manually updating the excel file, but...

       

      I hope there is a simple way to do this in PBI.

       

       

      • thakks's avatar
        thakks
        Helper I
        7 years ago

        I stumble to the same error message, can you poing me to the solution you referring to through Excel and VBA by any chance PaulDBrown 

        Web.BroserContents currently supports only anonymous credentials.

         

        Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-lili6-msft 

    Thank you for your reply!

    I keep getting an error message " The credentials provided are invalid "