Forum Discussion
Dashboard refersh issue
In my power BI dashborad after I'm refershing the data they can not be refersh they only loading option show , but data is not propertly refersh , they table
I have a data model that’s around 4GB in size, and it refreshes smoothly despite its size. The key reason is that there are minimal transformations done within Power BI’s query editor — only basic steps like filtering and column removal. All complex transformations have been pushed back to the source system, which significantly improves performance during refresh.
It’s important to note that both the nature of the transformations and the performance of the data source itself are critical factors when evaluating refresh times. Even large models can refresh efficiently if heavy processing is handled upstream and the Power Query layer is kept lean.
10 Replies
Can you explain your scenario?
I tried refreshing each table one by one. Some tables are getting refreshed, but the fact table is not refreshing. It stays stuck at 'fact loading' and 'evaluating.' My PBIX file is 1.3 GB and contains a lot of data, which is useful. So what should I do to ensure the data gets refreshed?
v-venuppuCommunity Support
Hi vikramkashid ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you danextian rajendraongole1 Anonymous for the prompt responses.
I wanted to check if you had the opportunity to review the information provided by rajendraongole1 . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Regards,
Rama U.
- rajendraongole1
Super User
Hi vikramkashid - can you check the below dashboard checklist:
1.Refresh one table at a time to find the blocker
2.Open Power Query Editor and step through the queries
3.Clear and re-enter credentials
4.Reduce the data volume temporarily
5.If online, check refresh history and gateway status also in services, Go to Workspace > Dataset > Settings > Data Source Credentials reconfigure if reuqire.Hope the above points helps.
- danextian
There could be several reasons for this. Are any error messages showing up? If so, what do they say? Also, what are the data sources you're using? How large is the dataset, and how complex are the transformations involved? Are you refresing in Desktop or Service?
I'm using in power bi desktop and source is analytical service data is to much size . but In fact table is not refresh
- danextian
I have a data model that’s around 4GB in size, and it refreshes smoothly despite its size. The key reason is that there are minimal transformations done within Power BI’s query editor — only basic steps like filtering and column removal. All complex transformations have been pushed back to the source system, which significantly improves performance during refresh.
It’s important to note that both the nature of the transformations and the performance of the data source itself are critical factors when evaluating refresh times. Even large models can refresh efficiently if heavy processing is handled upstream and the Power Query layer is kept lean.
- v-venuppu
Hi vikramkashid ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Regards,
Rama U.
- v-venuppu
Hi vikramkashid ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Regards,
Rama U.
- v-venuppu
Hi vikramkashid ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
Regards,
Rama U.
