Forum Discussion
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. The problem is in excel pivot table when I sort the dates in a different way to the data source order it doesn't work ( for any of date fields: date , month, period or MM-YY). I understand excel doesn't recognise Date data from Power BI as a number, but this is happening also with month number or period.
Any suggestion?
Thanks in advance
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.
