Forum Discussion

ryand009's avatar
ryand009
Frequent Visitor
1 year ago
Solved

Date sorting from Analysis services model

Hello

 

My PBI report data source is an analysis services database. In the report I only see the Model and Report views as below. My question is how do I sort dates with this data source?

 

 

In the model view of the PBI report, I don’t have the sort option on the date table, or the option to select a table as Date table?

 

The version of PBI we are using is December 2023?

Thanks in advance

Roy

 

  • ryand009 if you are using the analysis service db as a source and using a live connection, you have to make changes on the analysis service side.

2 Replies

  • ryand009 if you are using the analysis service db as a source and using a live connection, you have to make changes on the analysis service side.

  • ryand009's avatar
    ryand009
    Frequent Visitor

    Thanks for the quick reply

     

    What changes do I need to make?