Forum Discussion
Continued ContributorWhat'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
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?
5 Replies
- GilbertQ
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?- julsr
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?
