Forum Discussion
PBI Service refresh empty columns
Hi, delmayhan
This issue can be caused by an inconsistent date format between the Power BI Desktop and Power BI services. Make sure that the date column is formatted correctly in the query editor. When refreshed in the Power BI service, they may invert the day and month, with the day showing as the month and the month as the day. Changing the column type from Text to Date might fix the issue.
You can refer to the following posts:
Solved: Power BI Service - Data Missing after refresh - Microsoft Fabric Community
Solved: Data missing after service refresh - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, delmayhan
This issue can be caused by an inconsistent date format between the Power BI Desktop and Power BI services. Make sure that the date column is formatted correctly in the query editor. When refreshed in the Power BI service, they may invert the day and month, with the day showing as the month and the month as the day. Changing the column type from Text to Date might fix the issue.
You can refer to the following posts:
Solved: Power BI Service - Data Missing after refresh - Microsoft Fabric Community
Solved: Data missing after service refresh - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
there are also other columns which don't have data after the refresh.