Forum Discussion

ludovit8's avatar
ludovit8
Helper I
8 years ago
Solved

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  :-(.  H...
Need Help
  • zoloturu's avatar
    zoloturu
    8 years ago

    ludovit8,

     

    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)

     

  • ludovit8's avatar
    ludovit8
    8 years ago

    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).

     

     

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

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.

  1. Which source type do you use? (SQL Server, Azure SQL, SSAS, Excel etc.)
  2. Do you use Data Gateway to connect to your source?
  3. Which connection type you have in the report? (DirectQuery/Import/Live)
  4. Are you Free or Pro Power BI Service User? 
  5. Do you have Power BI Premium capacity?
  6. Are you an admin on your PC?

 

ludovit8's avatar
ludovit8
Helper I
8 years ago

Details:

- mostly sql and some excel

- If I understand it correctly, yes I have on-premises data gateway (personal mode) for daily data update, but I usually refresh it manually. 90% of data sources are sql database, not big, maybe up to 1 ir 5 thouasnds rows.

- I am pro power BI user.   [email protected]

- I dont have power Bi premium capacity, I dont know what it is.

- Yes I am admin. But problem is not only in PBI desktop, it is slow also in PBI could = your services/hardware