Connect Power BI to Rest API by Live Conncection or Direct query

[Anonymous]

I have a Power BI Rest API which i need to connect from power bi and show live data in report as and when it is connected. I searched power bi Documents in microsoft. Push dataset creates a API which can be connected to our device. But i dont want this because i already have a API and i need to connect this API to power bi in direct query or Live mode.

[Anonymous]

@parry2k  Thanks for your reply. 

My requirement is once the transaction is created user expects to see the record in report as soon as possible. Thats the reason we want direct query. 

I could not connect use transaction system as source directly since it is not a single system. Api will fetch from multiple sources. 

Hope i explained in detail. Please feel free to let me know if you need any other details 

[parry2k]

@Anonymous Unfortunately not all sources can be connected as a DQ. you have to use push dataset or use import. what is the reason for using DQ? 

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️