Forum Discussion
Solved
Blank dates in PowerBI report
Hi, I am refreshing my report in PowerBI service via access to an underlying sharepoint data. The data set gets refreshed with the latest data but does not pull date fields. When the same report ...
- Can you test if your date column has errors that will be saved as blanks during the Power BI service refresh?
It may be a date conversion issue, because your Desktop uses a different locale than the service. You may try to do the date conversion with a specific locale. Check this: https://www.excelguru.ca/blog/2015/07/08/fix-date-errors/
Maybe this leads you to a solution?
lndnbrg
Resolver III
Resolver IIII would try to change the data type by setting the locale explicitly:
In Power Query Editor, right-click on the column header / "Change Type" / "Using Locale..." / then choose Date format with the locale you want
source:
https://community.powerbi.com/t5/Desktop/date-format-is-changed-in-power-bi-desktop/m-p/45385#M17618
In Power Query Editor, right-click on the column header / "Change Type" / "Using Locale..." / then choose Date format with the locale you want
source:
https://community.powerbi.com/t5/Desktop/date-format-is-changed-in-power-bi-desktop/m-p/45385#M17618
Ok, I'll try.