Forum Discussion
Post ProdigyRefresh Every 5-10 minutes
Hi ElliotP
If you are connecting using Azure SQL Database, it is by default then connecting using DirectQuery. So what that means is that everytime you click on something in your report, it is sending a query back to your Azure SQL Database in realtime and returning the results.
Your dashboards are automatically refreshed every 15 minutes, and there is the possibility to change this in the service.
You can find more details with this here: https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/
I was wondering if it was possible with a pro license (or even a free) to refresh a dashboard/report every 5-10minutes? No, not with those license types. Premium offers much more refresh times but that is because it is in an isolated capacity.
I've seen the option to use streaming analytics but I'm not sure how I would be able to use this as well as apply my transformations in powerbi desktop as so the end user sees my work with the data.
I don't understand the last part of this. You can use API's to push data into Power BI.
I've seen the option for DirectQuery, but from what I've read I encounter the same issue as immedaitly above.
What issue? If the data source supports DQ then this option is optimal as the report would be a live look at what is in the data source. As the user interacts with the report they would see the latest information.
ElliotPAnonymousThanks for the quick response.
Right, that's interesting about premium.
In regards to Streaming Analytics, I can see where you can add the Real Time Streaming of data option (videos, personal experience, etc); but what I don't understand is how I would be able to apply the transformations, measures, etc that I do in powerbi desktop for example. Without being able to apply these transformations, use my measures, etc then it is very much just showing streaming data, that's it.
In regards to DQ, I'm using an Azure SQL Database so I think it supports DQ. From what I've read I'll have the same issue as above where I won't be able to apply transformations and measures upon the data before it is published to the web to be consumed.
- GilbertQ
Super User
Hi ElliotP
If you are connecting using Azure SQL Database, it is by default then connecting using DirectQuery. So what that means is that everytime you click on something in your report, it is sending a query back to your Azure SQL Database in realtime and returning the results.
Your dashboards are automatically refreshed every 15 minutes, and there is the possibility to change this in the service.
You can find more details with this here: https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/
- ElliotP
This is interesting.
I'm attempting to change the type of a column from an sql table in powerbi desktop to datetime and it isn't allowing me as it says it isn't supported in Direct Query.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/
I see that special treatment of dates is a limitation. In my sql database my DateTime Column is held as a String data type, would converting it to DateTime solve this issue?
Otherwise, how often am I able to refresh my reports using imports? Once an hour? 8 times a day?