Forum Discussion
Bi Service Error: Refresh took too long to complete.
Hi experts, needs a help with error in refresh though the data size is not more than 25MB( source is sql ). Even in power bi desktop the dataset is loading in query, however the refresh never comple...
ribisht17
Super User
Super User
Some of the best practices that can help you
- Remove unnecessary columns
- Remove unnecessary rows
- Group by and summarize
- Optimize column data types
- Preference for custom columns
- Disable Power Query query load
- Disable auto date/time
- Switch to Mixed mode
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series