Forum Discussion
Web connector returning excel file - Multiple API calls on refresh
Hi, We're working to set up an integration from PowerBI (desktop for the time being) against a REST api. The REST API responds with an excel file (xlsx). PowerBI designer works great in that i...
Are there any plans to change this?
A motivation for us to go with this approach was because of the ease of use of the set-up and the ability to deliver all of the data at once.
As owners of the endpoint we planned on writing instructions for users to connect; having them write M (or copy/paste) is a whole different story.
Could you explain the behavior for PowerBI online (once published)? We didn't test yet, but should we also expect it to make multiple calls?
Anonymous ,
I am afraid that there is no plan to change this. In your scenario, you can use fiddler to check the web call after publishing PBIX file to Power BI Service.
Regards,
Lydia