Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.