Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I would like to directly connect Power BI to data that is accessible by a REST API Endpoint. However, to access this data-containing endpoint, I first have to use my Web SSO username and password to get an authentication token from a separate API endpoint. This token will be valid for 12 hours for the same user. Using this token, I can go to the original endpoint, authenticate, and pull the data that I want. So far, I've just been doing all of that in Python. After I get the JSON data in Python, I convert to an Excel, and then use that Excel as a source for Power BI. It's not very efficient.
My question: Can I do all of this in Power BI Desktop?
The API Endpoints (example links - not allowing unlink for some reason):
Is is possible to do this in Power BI Desktop? Or maybe, is there some way to integrate my Python script? As in, there's a Power BI mechanism that calls my Python script, asks the user for log-in input(username, password), gets the Authentication Token, then asks the user for what data they want from the actual endpoint, uses their inputs from that and the previously recevied Token to get all the data? This would make the data-gathering process a lot cleaner, as I don't have to use a bunch of Excel files. Plus a report viewer could bring in new data from the API Endpoint, if they have the access rights to log-in to it.
@Anonymous , refer if these can help
Token based Auth
https://www.youtube.com/watch?v=f7HLyiAk-lQ
https://community.powerbi.com/t5/Desktop/Connect-to-data-with-API-token/td-p/731867
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/
https://docs.microsoft.com/en-us/rest/api/power-bi/embedtoken
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |