Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a pay as you go subscription to Azure. I noticed that the Power BI reports written with Direct Query have been scheduled to refresh every hour. Does anyone know if this could be adding to my monthly Azure subscription costs? Is there any point to a scheduled refresh if the Power BI report is written as Direct Query?
Thanks
Solved! Go to Solution.
It all depends on your Azure subscription.
1. If you are using Power BI Pro, there would be no additional cost to refresh hourly (though there are limitations on how many times you can refresh in a day)
2. If you are using Direct Query, you don't need to refresh the data since Power BI is directly interacting with data in the database.
3. If you are using a database as part of your Azure subscription, depending on how the subscription is setup, you might incur cost for querying the database using Power BI.
I'm getting this message when I open a PBI reportd with direct query. I don't understand why?
@MEFOX wrote:I'm getting this message when I open a PBI reportd with direct query. I don't understand why?
Please create another forum post since this is a new/separate topic/question. Power BI Service will disable refresh if the report hasn't been used for a long time. See below.
After two months of inactivity, scheduled refresh on your dataset is paused. A dataset is considered inactive when no user has visited any dashboard or report built on the dataset. At that time, the dataset owner is sent an email indicating the scheduled refresh is paused. The refresh schedule for the dataset is then displayed as disabled. To resume scheduled refresh, simply revisit any dashboard or report built on the dataset.
It all depends on your Azure subscription.
1. If you are using Power BI Pro, there would be no additional cost to refresh hourly (though there are limitations on how many times you can refresh in a day)
2. If you are using Direct Query, you don't need to refresh the data since Power BI is directly interacting with data in the database.
3. If you are using a database as part of your Azure subscription, depending on how the subscription is setup, you might incur cost for querying the database using Power BI.