Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

Best practice to read tables from Web.Contents source

Hello, how to set up web.contents 1 source query and read tables from it using referenced queries to not overload power bi? (not load web contents source multiple times). The issue was describ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jaryszek,

     

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    To avoid multiple Web.Contents calls in Power BI, create one base query with the Web.Contents call and reference it in other queries. Do not duplicate the call. Then, disable parallel loading of tables in Power BI (under Options > Data Load) to ensure the base query result is reused. This prevents redundant HTTP requests, as explained in Blog

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


    Regards,
    Vinay Pabbu