Limit of daily requests

[JuanLavagnini]

I’m facing an issue with the number of queries Power BI is making.

I need to extract information from a CSV file hosted at an endpoint. The problem is that the system has a limit of one query per day and powerBi is making multiple requests.

Using a sniffer I can see that in one of the cases powerBi is making three requests where two of them are being aborted while the server is sending the response.

[v-pagayam-msft]

Hi @JuanLavagnini ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.If our community members repsonse addressed your query, please mark it as Accept as Solution and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @JuanLavagnini ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by community members. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.
Thank you for being a part of Microsoft Fabric Community Forum!

[rohit1991]

To reduce Power BI queries to your endpoint:

1. Cache Data Locally: Download the CSV once daily and point Power BI to a local file or SharePoint.
2. Disable Parallel Loads: Go to File > Options > Data Load and uncheck Parallel loading.
3. Consolidate Queries: Merge transformations in Power Query to minimize calls.
4. Use Dataflows or Incremental Refresh: Store data in a dataflow or enable incremental refresh.
5. Adjust Query Folding: Ensure no unnecessary folding triggers extra calls.
6. Limit Refresh Schedule: Set the dataset to refresh only once daily in Power BI Service.

[v-pagayam-msft]

Hi @JuanLavagnini ,

Thank you for reaching out to the Microsoft Fabric Community Forum about the issue you are encountering.
After reviewing the issue, providing the insights as per my undestanding which might assist you in resolving the query:

1.Use Power Query to reduce redundant steps that might cause multiple queries.
2.Try to retrieve the CSV data and store it either locally or in a database(Azure Blob Storage or a Lakehouse)and connect Power BI to this intermediary storage.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

[ZhangKun]

https://learn.microsoft.com/en-us/power-query/multiple-queries

usually because of multiple references the query, or uncached data

[BA_Pete]

Hi @JuanLavagnini ,

Difficult to give a very detailed answer based on the information provided but, based on the info at hand, I would probably recommend creating a Datatflow (DF) for this CSV file which has a single query in it that pulls the file and maybe does some basic transformations on it. Set this to refresh once per day. Then you can use this DF as the source for any/all of your reports in which you can duplicate/reference the query and not increase the calls to the original source.

Pete