Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
julsr
Helper II
Helper II

What's considered as a query in PowerBI Datasets on Direct Query mode?

Hello Everyone!

 

I'm using a Direct Query connection (Power BI Dataset in Direct Query mode) to my Databricks Serverless account, which is activated when it receives a query and bills us for this. To ensure the pricing, I want to understand when a query is sent to Databricks. Are these options valid?:

  • When the scheduled refresh is performed in the PowerBI Dataset?
  • When some user opens a PowerBI report linked to the Direct Query Dataset (updated once per day)?
  • When the users change the filters to the report linked to the Direct Query Dataset (updated once per day)?

If there are more cases, it would be appreciated to know about them

Thanks

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @julsr 

 

What I would say is that everytime a user interacts with the Power BI Report it will run a query. So if the user then clicks on a bar in a table that will also send a query. And there is a potential for multiple queries to be sent per user interaction with the Power BI Report.


I would strongly suggest testing this yourself to see how many queries are actually generated when you use the Power BI Reports?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

Hi @julsr 

 

What I would say is that everytime a user interacts with the Power BI Report it will run a query. So if the user then clicks on a bar in a table that will also send a query. And there is a potential for multiple queries to be sent per user interaction with the Power BI Report.


I would strongly suggest testing this yourself to see how many queries are actually generated when you use the Power BI Reports?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thanks for your reply. I thought it would only be when the scheduled refresh is submitted, but if it's sent each time a user interacts with the report, it'll be a lot of times. Di you know how could I test it?

Hi @julsr 

 

You can create the directQuery for your Power BI Report to databricks. Then interact with some reports.

You should be able to monitor the queries on your databricks solution. Which you can determine how many queries are being run.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Great, thanks! Did you get this information from PowerBI documentation? Could you share it with me, please? I want to investigate further on this.

 

Thanks

Hi @julsr 

 

I have looked at the DirectQuery documentation in the past which details how to view and troubleshoot potential  issues with DirectQuery.

 

I would recommend that you do a lot of testing. Not only can there be a financial impact when a lot of queries are run on your Databricks  instance. But the Power BI reports could potentially also be very slow for the end users.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors