Forum Discussion
Why is loading/refreshing data in powerbi cloud or same problem also in desktop so slow ?
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).
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
Anonymous,
- You've said that it is not convinient to use settings per each file? Can you describe why?
- One of the improvements can be to set SQL Server Analysis Services (SSAS) Tabular instance on your machine between your sources and Power BI reports. As result you will have:
- Ability to connect Live to your SSAS database. Much more faster then other connection types. Automatic refresh of report from SSAS
- You will import all your sources to one SSAS database. Easy to build new reports. Only one source to connect to
Hi zoloturu
I can see the benefits here however it's inconvinient because I'll have to go into each report, set the option and publish it again. The manual part of this job bears the inconvience.
Anonymous,
Do you look into speed improvement on reports in Power BI Service only? (Do not tuch Desktop and republish)?
If so, then you need to buy capacity:
- Power BI Embedded (on the Azure portal)
- Power BI Premium (on the Office 365 portal)
Then go to Power BI Service -> Settings -> Admin portal to assign your workspaces to capacity
We are yet to buy capacity therefore cannot try that option. However; even if we had bought capacity, I wouldn't be keen to try that option simply because it creates governance issues. It will cause PBIXs to get out of sync with published reports.