Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ...)
Would be great to hear if anyone else is experiencing similar issue with the refresh from Analysis Services?
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
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
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |