Forum Discussion

bewilson's avatar
bewilson
New Member
3 years ago
Solved

Table not Found

Looking for some help...I am attemptiing to load new Data into Power BI Desktop by utilizing Get Data-->web.  I keep getting "We didn't find any tables on this web page."  However, I am able to use the same link and load into excel with no issues.   Any suggestions?

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi bewilson ,

     

    According to my tests, the same link scraped data is different in Power BI Desktop and Power Query Editor in Excel.

    If you don't mind, you can first get the web page data in Excel, and then connect Excel in Power BI to get the web page data you want.

                                                                                                                                                             

    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.           

2 Replies

  • foodd's avatar
    foodd
    Community Champion

    Are you using the same Power Query script from Excel Power Query to Power BI Desktop?   Reply with a screenshot, as well as the URL and script that you are using.    Does the webpage require any special authentication?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi bewilson ,

     

    According to my tests, the same link scraped data is different in Power BI Desktop and Power Query Editor in Excel.

    If you don't mind, you can first get the web page data in Excel, and then connect Excel in Power BI to get the web page data you want.

                                                                                                                                                             

    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.