Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 calling the service twice when I test it. It calls once to pull data into the preview page in Power Query, and then it calls again when I hit "Close & Apply" to load it all into the report builder.
Is anyone able to provide some insights into this workflow to help me limit double-paying?
For example, with a 5,000 row query, does the desktop tool:
Any help on this matter would be greatly appreciated!
Solved! Go to Solution.
The api will only be called in power query for one time.
Regards,
Jimmy Tao
@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.
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?
Million dollar answer, thanks Jimmy!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |