Forum Discussion

jitpbi's avatar
jitpbi
Icon for Post Patron rankPost Patron
5 years ago

all queries request when editing one query

Hi,

 

I am getting data from a web source in my report. The report is having 5 different queries/tables which URLs are like below:

180.10.3.12:10000/BC/v5/KOJ/TMK/MCG/TPI1

180.10.3.12:10000/BC/v5/KOJ/TMK/MCG/TPI2

180.10.3.12:10000/BC/v5/KOJ/TMK/MCG/TPI3

180.10.3.12:10000/BC/v5/KOJ/TMK/MCG/TPI4

180.10.3.12:10000/BC/v5/KOJ/TMK/MCG/TPI5

 

The problem which i am experiencing is when i am editing/refresh a single query, out of these above 5 URL, in power bi desktop it sends request for all urls to the source server (180.10.3.12:10000). these requests go even if i simply click on tranform data. this increases the unnecessary load on the source and in result a huge delay in getting the response or failure many times.

 

If i edit for single table/query (for e.g. 180.10.3.12:10000/BC/v5/KOJ/TMK/MCG/TPI4) the request to the source should go for this query only.

Is there any standard setting available in PBI desktop to fix this or any possible way to stop sending these multiple request to source?

 

Please suggest.

 

Thanks

 

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    jitpbi you can add a paramter wiht yes/no and in desktop keep it "No" and in this case only process one URL for development, once you are happy publish the report to Power Bi service and under Power BI dataset change the value of this parameter to "Yes" and once it is refreshed in Power BI service, based on the logic all the URLs will refresh.

     

    Also, turn off Parallel loading of tables:

     

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • jitpbi's avatar
    jitpbi
    Icon for Post Patron rankPost Patron
    5 years ago

    Hi parry2k ,

     

    Thanks for the suggestion.

    I can change the data load setting for paraller loading but not very clear on parameter.

    It would be great if you can explain bit more on the parameter, i mean how to do this exactly.

     

    Thanks

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    jitpbi bit hard to explain, look thru this post and basically you can use the same approach to not process 4 links but only process one but in service change the parameter to process all 5.

     

    If you still not able to get thru this, let me know.

     

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi jitpbi ,

     

    Are you saying that if you refresh only one table, other tables will also be refreshed?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.