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.
Hi, all,
I need to import data from restful api, the api need bear token to request.
So currently I import dataset by python script in Power BI Desktop, and it works well.
The python script imports "datetime,msal,pandas,requests" module, it would acquire token first then call two RESTful API and merge them as one pandas DataFrame.
In the future I am going to enable schedule refresh in Power BI Service. So I would like to know:
1. Could I pass argument to python script since AAD authorization requires client secret?
2. Could python script dataset suitable for Power BI Service?
Or, could anyone suggest me another solution to get the data from AAD Authorization API? Like by Power Query?
Thank you!
Solved! Go to Solution.
Solve it by myself.
I use Azure Function with basic auth to wrap the AAD authed API.
Solve it by myself.
I use Azure Function with basic auth to wrap the AAD authed API.
@dm-p , @ImkeF @edhans @HotChilli
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.