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'm having troubles to set up auto refresh when I use http request using url with token authentication. It works in power bi desktop, but I cannot set up auto refresh in power bi service. It doesn't accept Anonymous Authentication method.
Data are extracted as follows:
= Web.Contents("https://app.idoklad.cz/developer/api/IssuedInvoices?PageSize=1000000&Page=1",[Headers=[#"SecureToken...; = "<mytoken>",#"X-App" = "iSmart",#"X-App-Version" = "1.0"]])
Url shows only https://app.idoklad.cz/developer/api/IssuedInvoices?PageSize=1000000&Page=1, without authentication part, so it is obvious that it doesn't accept Anonymous authentication. But how I can provide token using power bi service?
Thanks for help,
Lubos
Solved! Go to Solution.
As mentioned in this similar thread, this is not possible due to constraints with the way Web.Contents stores credentials. And there are also some workaround mentioned in that thread, please go and try to see if the solution works.
Regards
As mentioned in this similar thread, this is not possible due to constraints with the way Web.Contents stores credentials. And there are also some workaround mentioned in that thread, please go and try to see if the solution works.
Regards
Thanks for your help @v-ljerr-msft. Workaround with RelativePath worked for me. Great!
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.