Refresh works in Desktop but fails in Service

[WiVa]

I build a PBI Model using some local files as well as data from a web source, which I connect to through an API. Everything works fine in the Destop Version including the data refresh from the web source. However, when publishing to the Service, a refresh of the web source is not possible; I get the following error message:

 I used relative path and query in the query description, so that should be okay. However for some reason, PBI Service translates the Ampersand (&) into a unicode (\u0026, see marked in yellow). I assume that that causes the problem.

Can anyone help to solve this? 

Thanks a lot!

Best regards, Wim

[WiVa]

Hello Otravers and  V Yangliu

I followed the hint from Otravers and have eliminated the original error, by also connecting to the web source using the gateway. Also, for all the sources I set the privacy level to Private. Howerever now I get another error. It says "A connection to the data source "undefined" could not be established." Further details only show an activity ID and a Request ID, so no Error code... Any Idea how to solve this now?

[otravers]

This is too vague to be able to offer much advice (not your fault, these error messages are often fairly generic).

Can you try putting your queries in a dataflow to see what happens there? Might be easier to troubleshoot out of the dataset.

[v-yangliu-msft]

Hi  @WiVa ,

This may be related to the privacy of the firewall:

https://docs.microsoft.com/en-us/power-query/dataprivacyfirewall

This is the related document, you can view this content:

https://community.powerbi.com/t5/Service/Unable-to-combine-data-Please-rebuild-this-data-combination...

https://community.powerbi.com/t5/Desktop/unable-to-combine-data-Please-rebuild-this-data-combination...

https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[otravers]

You have a privacy issue when combining your queries. Read this entry:

https://blog.crossjoin.co.uk/2019/01/13/power-bi-data-privacy-cloud-web-data-sources/