Forum Discussion

celestineneo's avatar
celestineneo
Frequent Visitor
3 years ago

Unable to connect to web API

Hi All,   I'm relatively new to this, and have tried searching high and low for answers but i'm not able to find one. Would appreciate any form of help.   I've been trying to connect Power BI to ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi celestineneo 

 

I usually use the solution introduced in this blog (Scrape Data from Multiple Web Pages with Power Query) to get data from multiple web pages. You can transform the successful query into a custom function with a page number parameter. Before that I recommend that you edit the URL in Advanced Editor to do a test to check whether you can get data from other pages by only modifying the URL in the successful query. 

 

In below screen, select the base url without page number param in "Select which level to apply these settings to" dropdown box. Keep using Anonymous type. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • celestineneo's avatar
    celestineneo
    Frequent Visitor
    3 years ago

    Hi v-jingzhang,

     

    Thanks for your reply. Unfortunately, the video does not help as I am stuck at the step before that. 

     

     I think before I am able to extract all content, I must be able to query at least one page (other than page 1)..

     

    I just find it strange that I am able to run the URL (with page number) on Postman, but not able to run it on Power BI (It keeps saying they cant authenticate with the credentials provided)...

     

    Please let me know if you have any other insight! Greatly appreciate it.