Direct Query reverts to refresh schedule in service

[madumi83]

I created a report from a Dataverse table using Direct Query and within Power BI Desktop. I then published that report to the service, hoping that I could obtain a live update of the data. However, I notice that under settings, it has reverted to a one hour refresh schedule.

Is it possible to have the report display a live update of report data within the Power BI service? (we have some people in our company who either don't know how or don't wish to locate & use the refresh button under the semantic model).

Thanks!

[madumi83]

Thanks so much @collinq , I think the licensing would be the bottleneck in my situation. Thanks for pointing that out!

[collinq · Accepted solution]

Hi @madumi83 ,

I do not think that the issue is that you have a direct query or that it is Dataverse.  I am thinking that your issue is the licensing and/or the setup.  For live data, you need to have real-time streaming setup.  This article discusses the setup for that:  Real-time streaming in Power BI - Power BI | Microsoft Learn   
The minimum license for this is going to be Premium capacity or PPU.

Also, as a rule, you shouldn't have users with the ability or the need to hit "refresh" on the model.  You should only be sharing the output of your report in an App and make sure that they can't do their own refreshing.  This can lead to all sorts of issues in capacity and data integrity if users are refreshing the data on their own and at their own times.