Forum Discussion
Hsilva
Helper I
Helper IExcel get data from Power BI doesn't recognize Dates as Number and cannot be sort.
Hello community, I have a pivot table connected to a Power BI data model (get data from Power BI), in the data model the Month-Name and MM-YY columns are sorted by another column and woks perfect. ...
Hi Hsilva
What I have found is that you need to create a date table and link your date column to the date table. Then make sure to mark your date table as a Date TABLE.
Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn
Then once that is done and you have uploaded your Power BI report to the service, then connect with Excel and it should work with the dates.
