Hi All,
The below link would give us difference between live connection and direct query
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
If you want Rownumber in DAX use RANKx
=Rankx(Tablename,columnname)
Viola..you have your distinct row number :)