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.

[BA_Pete · Accepted solution]

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

[ZhangKun · Accepted solution]

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

usually because of multiple references the query, or uncached data

[v-pagayam-msft]

Hi @JuanLavagnini ,
I wanted to check and see if you had a chance to review my previous message or Please let me know if everything is sorted or if you need any further assistance.If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you for your cooperation. Have a great day.

[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 · Accepted solution]

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 · Accepted solution]

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

usually because of multiple references the query, or uncached data

[BA_Pete · Accepted solution]

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