Forum Discussion
Missing data after scheduled refresh
Hello,
I have created report in Power BI Desktop, which takes data from 3 different tables of SQL.
After some scheduled refresh, data from one column disappears.
But it's temporary, after next refresh or manual refresh it appears again.
I have premium and dataset updates in every 30 mins.
I have another report published, and have same problem with same data ( source is same table from SQL).
Notice, these data doesn't disappear at same time on both reports.
How can I fix this?
Thanks
2 Replies
- v-luwang-msftCommunity Support
Hi Shurga ,
Does the column name disappear when the data in the column disappears?
Is the version of the gateway you are using the latest version, try updating the gateway to the latest version.
Also try, create a static copy of the table that is having problems in the database, create a new report based on the copy and configure a refresh, and try it.refer:
https://community.powerbi.com/t5/Service/Power-BI-Service-Data-Missing-after-refresh/m-p/495798
Best Regards
Lucien
- v-luwang-msftCommunity Support
Hi Shurga ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien