Multiple API calls going to the Service

[hmokkapati]

Hello,

I have Power BI Query which has M Code to make a single API call. But when the query is monitored in Fiddler I see there are 2 API calls made.

I saw a similar thing in Power Query and Power Pivot too. Is it done once for ETL and once for loading into the data model? How can I limit it to make only one call as the API to which the call is made not only gets but posts data on the server.

Any pointers appreciated.

Thank You,

Harisha

[v-micsh-msft]

Hi hmokkapati,

Which API call that you have in the M code, would it be available to share some information about the API, and the Fiddler trace here?

I suspect this should be more specific with the API side. Some API would need verification first before getting the data.

In addition, I will perform some tests and see if I could find any helpful inforamtion.

Regards

[hmokkapati]

Hello Michael,

Thanks for your reply.

Unfortuantely cannot share the API details. Its internal.

But what I observed is when I choose to "Load it to data model" thats when it makes 2 calls, otherwise when its loaded to sheet/connection without loading to data model its called only once.

Thank You,

Harisha

[v-micsh-msft]

Hi hmokkapati, 

If the second call is made after clicking "load" or "edit" in the Get Data Wizard, then I don't think currently there is a way available to avoid it.

We may consider to make the API query into a function, so the next time when a new query needed, we could just enter the Parameter instead of re-writing the Query again.

Check the blog below and see if this would be helpful:

Querying the VSTS Work Items API directly from Power BI

Regards

[hmokkapati]

Hello Michael,

Below is the code to call the API and it makes so many calls whether its a success or failure....I can see there are multiple calls in Fiddler. Is there a setting in PowerBI that could stop from making so many calls in both scenarios. Attached are the calls in Fiddler in both cases. This affects the stability of the entire system..as the API call also Posts some data. These are calls from multiple queries when i do a "Refresh All". Please help.

let

//Get the dataset from Azure API that calls the Anaplan API
fileName ="LRP-PowerBI",
Datachunks=Csv.Document(Web.Contents(ExportURL & fileName)),
#"Promoted Headers" = Table.PromoteHeaders(Datachunks)

in

#"Promoted Headers"

Thank You,

Harisha