Forum Discussion
Why is loading/refreshing data in powerbi cloud or same problem also in desktop so slow ?
Every change of some selection start new loading/refreshing data but it is too slow. In PBI desktop but also in BI cloud.
Our manažment can not wait for every change in selection one minute :-(. How to make it faster?
Look on this video pls.
What I recommend to you in developing report is to use only tables and columns you need.
Your RAM spending = SUM of memory size of each field together
If you decrease number of columns using SQL then you will decrease it very much.
When you connect to your SQL Server/Azure SQL Database you can mention SQL script as shown below. It can be simple SELECT or something complicated as stored procedure which returns dataset
(In case of Analysis Services it can be written in MDX or DAX)
The best solution is this one.
http://community.powerbi.com/t5/Desktop/Combine-multiple-tables-into-one-table/m-p/60752#M24933
Now it works perfectly, everyrefresh/changing parameters in visualization takes 1-2 seconds.... I can consider this link as a solution for everybody who has problem with slow PBI with a lot of tables.
I have maybe 10 bookeepings joined in one table now, 10 tables of invoices joined in one table and so.... one added column in table to indentify company. And all those sources have in querries turn off "enable load" option (so total refresh is working but it is slowing down powerBI).
17 Replies
zoloturu Does this mean that we have to make this change to every PBIX and then republish it? If so, this is not very convinient solution.
Anonymous,
You are correct. These settings should be applied to each file separately.
Give me some more details on your reports and systems. I will try to give an alternative.
- Which source type do you use? (SQL Server, Azure SQL, SSAS, Excel etc.)
- Do you use Data Gateway to connect to your source?
- Which connection type you have in the report? (DirectQuery/Import/Live)
- Are you Free or Pro Power BI Service User?
- Do you have Power BI Premium capacity?
- Are you an admin on your PC?
Hi zoloturu
Here we go;
- Which source type do you use? (SQL Server, Azure SQL, SSAS, Excel etc.)
- On Prem
- SQL Server, Oracle, Excel, CSV, SSRS
- Cloud/Online Services
- One Drive, SharePoint Online, web sources
- On Prem
- Do you use Data Gateway to connect to your source?
- We have the Enterprise Data Gateway
- Which connection type you have in the report? (DirectQuery/Import/Live)
- Almost all of them are Import
- Are you Free or Pro Power BI Service User?
- Pro Users all of them
- Do you have Power BI Premium capacity?
- Not yet
- Are you an admin on your PC?
- I am admin on my machine, not sure of my business users who are PBI authors
- Which source type do you use? (SQL Server, Azure SQL, SSAS, Excel etc.)
