Scheduled refresh using SOAP Post Web connection

[Anonymous]

In Power BI Desktop I have successfully pulled in an XML response using a Web.Contents call and setting my Authorization and Content headers. In order to make a POST call you have to set Content correctly and pass the arguments in the body of the request. Once you do this, Power BI Desktop requires you to change Authorization type to Anonymous.

Now when I try to setup my data gateway in Power BI Report Service the only way I can connect successfully is to use Basic Authentication as I am not aware of a way to set the Authorization Header in the Manage Gateways UI. As soon as I change to Basic Auth I can connect to the SOAP url successfully but my Dataset fails to refresh because (it has to be Anonymous to do a POST Soap call):

Then of course once I set it to Anonymous I can't do an initial successful connection with my gateway because the URL wants authentication first:

Is there anyway to get around this?

[v-shex-msft · Accepted solution]

Hi @Anonymous,

If you are use online service as datasource, power bi service can direct connect to online service without gateway settings.(it will use 'connect directly' mode) You only need to update data source credentials on service side.

If you mean you are using mixed data source with online and on premise mode, if you do some advanced operations (append/merge,custom function) on these mixed datasource, oauth authorization will disappeared on service side.

BTW, custom function still not support on power bi service, you can consider to modify it to parametrized query.

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,

Regards,

Xiaoxin Sheng