Forum Discussion

sandykools's avatar
sandykools
Frequent Visitor
6 years ago
Solved

Does Query Reduction works for Power BI embedded, which is using direct query

Can we use Query Reduction Feature and PowerBI.preload() for the Power BI embedded dashboard where we use direct query?
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , sandykools 

Query reduction Feature may not work for embedded  dashboards (  there is no options to apply slicer and filter  on the embedded  dashboard)

Please refer to this article:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

PowerBI.preload()  It works in theory. But the actual effect still needs to be tested

https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-november-update/

https://docs.microsoft.com/en-us/power-bi/developer/embedded-performance-best-practices

 

Best Regards,
Community Support Team _ Eason

sandykools's avatar
sandykools
Frequent Visitor
6 years ago

 

 

Thanks for your response, Eason v-easonf-msft .

 

But when our dashboard is loading, we see same query is hitting the DB multiple times. As the webpage is waiting for all the 4-5 simlar queries to complete the execution, there is a time delay in page load. Also, we see all the SQLs generated are starting with Select Top (1000001). Is there a way to reduce the no. of SQLs issued to the DB, for PBI Embeded.

 

We were planning to implement PowerBI.Preload() function in our systems. As you said it still needs to be tested, I am worried if I can recommend this option to our management. 

 

Would you be able to provide me a reference or URL to any video, where this feature is demonstrated with an example. 

 

Many Thanks, 

Sandeep 

 

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi , sandykools
    Sorry ,I‘m not good at  Power BI embedded and don’t have any related videos.
    I suggest you to post your problem to the "developer column",  then you will get more  better answers.

     

    Best Regards,
    Community Support Team _ Eason

    • sandykools's avatar
      sandykools
      Frequent Visitor
      6 years ago

      v-easonf-msft Thank you, Eason for your support. Will post it in Devs. 

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        6 years ago

        Hi, sandykools 

        You’re welcome.

        If your problem has been solved, you can add your reply here and  mark  your reply as Answered to close this thread.

        Best Regards,
        Community Support Team _ Eason