This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I have an Azure Mobile App (https://azure.microsoft.com/en-us/services/app-service/mobile/) and I want to use PowerBI to connect to the data via its REST API. I've got it setup so users authenticate using Microsoft accounts. How can I connect PowerBI to it?
I see the Web data source, but have not been able to get it to work since MSA authentication in PowerBI is not an option.
I currently get to the data source via a direct Azure SQL database connection. I want to move away from that.
Hi @carlomendoza,
To connect to the Azure Mobile App REST API from Power BI desktop based on MSA authentication, you could try to append "username", "password", "access token" as the parameters to query string. But you should be aware that this token will be expired after a certain time. In that case, I think the best choice currently is to get data source via a direct Azure SQL database connection.
Reference: Get Data from Twitter API with Power Query
Issue with getting data via API with bearer token
Best regards,
Yuliana Gu
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 61 | |
| 35 | |
| 30 | |
| 23 | |
| 22 |