Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!