Forum Discussion

Hsilva's avatar
Hsilva
Helper I
3 years ago
Solved

Excel 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. ...
Need Help
  • GilbertQ's avatar
    GilbertQ
    3 years ago

    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.

GilbertQ's avatar
GilbertQ
Super User
3 years ago

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.

Hsilva's avatar
Hsilva
Helper I
3 years ago

Hi Gilbertm thank you for your help.

yes I have calendat table with a dete column (market as a date table) adn also linked to the date calumn from the fact talbe.