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:
This is a MUST…. to get Sheet summary reports in Power BI.