Previously I posted that the same function works in excel without problems.
But now I found that it works in the latest excel 2016 with problems either
And still if I paste produced url into browser - I get data without problems!
I don't know what changed in the product that could cause the difference in the behavior. It reproduces when using Fiddler, which seems to indicate that the service is closing the connection based on the HTTP request. Can you use Fiddler with PBI Desktop and Excel to determine what is different in the request? There may be something different, such as header.