Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data Refresh from Paid API

I'm working on a report that pulls data from a Paid API service, and need some help making sure that I don't over-pay for the data.   I can't tell, but  it seems to me that Power BI might be callin...
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Sjohnson ,

     

    The api will only be called in power query for one time. 

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

Loading data twice is normal. Power bi will load the data into data model in power query in the first time. After some data pretreatment, power bi will load the data into data view in the second time.

 

If you mean how to reduce the loading time and enhance the performance in power bi, I would suggest you to refer to tips of how to improve power bi performance below:

https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

 

Community Support Team _ Jimmy Tao

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

  • Sjohnson's avatar
    Sjohnson
    Advocate II
    7 years ago

    Thanks for the response v-yuta-msft !

     

    I understand that the data loads twice, but do you know if it calls the API twice? Or does it just call once and load twice?

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Sjohnson ,

       

      The api will only be called in power query for one time. 

       

      Regards,

      Jimmy Tao

      • Sjohnson's avatar
        Sjohnson
        Advocate II
        7 years ago

        Million dollar answer, thanks Jimmy!