Serial Number in a Report

[GuestUser]

Hi,

We have created a report in Power BI 

Datasource : Connect Live to SSAS Tabular Model

We need one column to display Serial Number (Row Num) in a report 

Add Index is disabled -- since we are using connect Live option

Can you pls suggest?

[v-lili6-msft]

hi  @GuestUser 

Since your data source is SSAS Tabular Model, you could only create measure for this report in power bi,

you could try these two ways:

1. Add an index column in SSAS Tabular Model.

2. Use RANKX Function to create a rank measure and use it as a Serial Number.

https://docs.microsoft.com/en-us/dax/rankx-function-dax

https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/

Regards,

Lin