Direct query of Web (Rest API) data source

[eddie_yasi]

It would be very helpful to be able to specify that a Web / REST API data source be accessed as a direct query. We have several dashboards with the requirement that any changes to the data are reflected IMMEDIATELY upon refresh, no delay due to caching is acceptable. Because we use a rest api for our data source in Power BI the only options we have right now are to create a CLR stored procedure and then do an OPENQUERY on that so we can do a direct query of that, or have our endpoint persist the data to a table which then can have a directquery select statement pointed to it. Neither solution is ideal and it would be great to just flag the endpoint as DirectQuery similar to database select statements

[dylan_morgan]

Really all that would need to happen is to enable the Web.contents method for Direct Query. That would enable custom connectors to leverage DQ...

[Javier_Rojas4]

We are looking forward to this functionality to have Azure Application Insights to be Direct Queried from PowerBI

[hossein_rahmani]

As you know REST API is a [de facto] standard in many areas. And it is supported by most of the other Microsoft products. I wonder how Direct Query is not compatible with Rest API data source!

I hope you will add this very useful feature soon!

Thanks and best regards.