Direct Query through REST API or oData

[Anonymous]

All,

We have a need to compute a KPI against a big data set. The client wants to use API instead of directly connecting to the database. Due to the size of the data (1.7M every hourly refresh), we would like to use the direct query mode calling REST API or oData.

I am very much to the API side and appreciate if you could provide any pointers on how we can achieve this. I couldn't find anything in the forums and/or documention related to direct query w.r.t. API.

Thank You

V.

[mwegener]

Hi @Anonymous,

has your question been answered?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi @Anonymous,

the REST API and oData connector do not support direct query.

Maybe Real-time streaming is the right solution for you.

https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.