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.
I am making a content pack for Power BI.
I am using REST API, but I have to use basic AUTH.
I need to pass the username and the password as parameters for the API call, not just a plain txt. So anyone can put in their own username and password and connect their own data to that content pack.
let actualUrl = "https://XXX/api/c/entities?type=TEM", options = [Headers =[#"Content-type"="application/json", #"Authorization"="Basic <User : Password>"]], result = Web.Contents(actualUrl, options) in result
How can I pass that user and password as parameters into the code? Or, is there any workaround?
Thanks in advance!
Hi @Anonymous
You may have a look at below post. If it is not your case, you may submit a support ticket.
https://powerbi.microsoft.com/en-us/support/
https://community.powerbi.com/t5/Report-Server/Power-BI-REST-API-authentication/td-p/295470
Regards,
Cheriee
Hello v-cherch-msft,
I have already seen those links, but I have to use M Formula Language.
I think I have found a partial solution:
let Source = let data = [ path= "/code", recursive=false, include_media_info=false, include_deleted=false, include_has_explicit_shared_members=false ], actualUrl = (InstanceURL) & "/api/c/entities?type=STR", Headers =[ #"User"=(Username), #"Pass"=(Password), #"Content-type"="application/json" ], result = Web.Contents(actualUrl, [Content=Json.FromValue(data),Headers=Headers]) in result in Source
It does log in if I do not add this piece of code:
& "/api/c/entities?type=STR"
But from the moment I add that piece of code it doesn't log in.
Note: InstanceURL, Username and Password are parameters.
Thanks for your time!
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.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |