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.
Hello, Power BI Community!
Could please someone explain why PostgreSQL receives several identical queries while refreshing one table in Power BI? The tick "Enable parallel loading of tables" is unchecked, it is just one table sending many queries to the database.
This enourmously increases the server loads and can lead to a server and database breakdown.
So basically, it's just one table that is refreshed, but it sends many queries. The same happens even in the process of opening the file.
The table consists of 2 appended tables: 1 table - CSV-file, with the data before 2019 and 1 table is directly connected to database. Amount of steps is minimal - 4 or 5 - like changed type or renamed columns.
This problem exists only with PostgreSQL.
Maybe someone knows how to reduce the load on database? And why this happens?
Thank you
Solved! Go to Solution.
Hi @Anonymous ,
Power BI sends several requests to a source to retrieve some metadata first, then the last one is to get data from a table.
Also, if you have some visuals and you use DirectQuery connection in your report then each visual will send a query to a source during report refresh and at each moment when you interact with visuals and filters.
In order to decrease amount of queries to your server you have 2 options:
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups
Hi @Anonymous ,
Power BI sends several requests to a source to retrieve some metadata first, then the last one is to get data from a table.
Also, if you have some visuals and you use DirectQuery connection in your report then each visual will send a query to a source during report refresh and at each moment when you interact with visuals and filters.
In order to decrease amount of queries to your server you have 2 options:
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups
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.