Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Scheduled refresh using SOAP Post Web connection

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):

 

SOAPAPI-1.PNG

 

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:

SOAPAPI-2.PNG

 

Is there anyway to get around this?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors