Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 is opened in PowerBI desktop and refreshed the dates appear Ok.
Any solutions ?
Solved! Go to Solution.
Yes, I use the latest versions. When I publish from desktop to service the dates appear. However on first refresh from service everything is updated apart from date columns.
Hi @namitsamal,
Can you share more detail info about create custom date column? It will be help for troubleshooting.
Regards,
Xiaoxin Sheng
The column is marked as a date time column in the source excel file. On import to PowerBI desktop the display format is changed as per requirements. When refreshed from the desktop the dashboard retrieves the latest data. When the dashoboard is published to PowerBI service and refreshed all the data is retrieved apart from those date columns.
I cannot use the old compatible excel format (.xls) as it requires me to install a driver on local machine since 64 bit latest PowerBI installation does not support that format. Everthing works fine when dashboard is refreshed from desktop but the columns are not retrieved when refreshed from PowerBI service. I cannot share the file or link as it contains client sensitive data.
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 ?
Ok, I'll try.