In my opinion, it is an embarrassment for the Product team to code only 1 of the 2 native types of reports that work work with the Power BI Connector - it's like a restaurant offering two dishes - chicken and steak - but only one of them comes cooked.
For those of us that don't have years to wait for Smartsheet to get it together, I found a reasonable solution thanks to YouTube.
Essentially:
- Recreate the report as a row report (so that it pulls into Power BI) - make sure that you have a column with dates to filter for your most recent records
- In Power Query Editor: sort the date column by descending (latest records at the top)
- In Power Query Editor: wrap the query with a Table.Buffer( ) - see video @4:52
- In Power Query Editor: remove duplicates based on the column where you want to filter by a unique record (ex: Employee #, Project Name, Sales Territory, etc.)