Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
@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
@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! ❤️
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @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! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.