Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there, I have a simple Excel file with a date in UK format (dd/mm/yyyy) as a data source to a Power BI report. When the file is stored on my OneDrive for Business the date appears correctly in the Excel file, PBI desktop and the PBI Service. However, when I move the file to a Sharepoint Document Library and change the data source in the desktop version of PBI to the Sharepoint document library, the Excel file and desktop PBI report are fine but the PBI Service has american format dates. Please can someone let me know how I can fix this issue?
Thanks......Steve
Solved! Go to Solution.
Microsoft very quickly responded and showed me that the date field in my desktop PBIX file was coming in from Excel as a text field. When we changed this to a date field, everything worked as it should.
Thanks Microsoft.
Thanks very much for your response, I should have said that I have checked the regional settings on my device and in the browser. I also tried a different browser. It was only when I copied my Excel file to my OneDrive for Business and changed the data source of my PBI report that the PBI service showed the correct dates. Changing the data source back to the SharePoint document library reinstated the error. I will double-check this result later today.
Steve
I have done some more detailed testing. If I revert to the OneDrive version of the file and publish the report, the dates go back to UK format. In PBI desktop, I can then change the source to the SharePoint Document Library and publish the report and it is still all correct with UK format dates.
However, once a scheduled update of the PBI Service updates the file, the dates turn American - surely this is a bug?
Steve
Thanks, I have logged this as a bug but I am still awaiting a response from Microsoft.
Steve
Microsoft very quickly responded and showed me that the date field in my desktop PBIX file was coming in from Excel as a text field. When we changed this to a date field, everything worked as it should.
Thanks Microsoft.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.