Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous ,

I am afraid that the above behavior is by design currently.

Power BI will request to get schema and data loading for each sheet, which makes multiple API calls on refresh. And if you turn on backgroud data option in Power BI Desktop, you will get additional API calls. You can disable this option to mitigate this issue.




Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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