Forum Discussion

maxsuharevsky's avatar
maxsuharevsky
Frequent Visitor
2 years ago

PBI Desktop - Refresh is not counting rows

I am connecting to SQL Analysis Services and when Refreshing tables rows count is stuck at the same number of rows and not displaying the progress, eventually, it completes the refresh but sometimes (due to the size) it times me out. 
How to display the progress so that I can see growing rows? If connecting to excel table or csv MB size is dynamically growing but when via refreshing Analysis Services it stuck at some random number (see below = 403 rows from ...)

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi maxsuharevsky ,

    Try Disable Parallel Data Loading:  Options and settings -> Settings -> Under Current File -> Data Load -> Parallel Loading, check the disable parallel loading option.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

    • maxsuharevsky's avatar
      maxsuharevsky
      Frequent Visitor
      2 years ago

      Hi Gao, I have checked that option and unfortunately still when refreshing the table the row count is stuck at randon number 😞

      Please see my settings below

      Thanks and awaiting for more tips.

       

      Global > Data Load

      Current file > Data Load

       

       

    • maxsuharevsky's avatar
      maxsuharevsky
      Frequent Visitor
      2 years ago
      Maybe you have another solution as it is still not working for me the way it should work. Thanks