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 IIICan 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?
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?
Thank you, it was indeed a date conversion issue. I was able identify it by using a different date format in the source excel file. The second step was to avoid any conversion when the file is imported in PowerBI desktop "Edit Query". I am able to view the data in the PowerBI service. PowerBI desktop does not recognise this universal date format as date when imported, if I change it to date in "Edit Query" and publish the dashboard the problem persists. What should I do ?
- lndnbrgI 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 Ok, I'll try.