Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |