Hi @HCC1 ,
I tried to find a way to change the row display settings in URL itself, but did not manage to do so...
Other people tried to use an API:
Bringing in api data from Bureau of Labor statisti... - Microsoft Power BI Community
And here they used the URL in combination with a function:
Solved: Trying to connect to Bureau of Labor Statistics, b... - Microsoft Power BI Community
I saw, however, if you press the Download Source Data button, you can get the underlaying source data in the csv format. This one you can call directly from the URL, too. Could this be something for you?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!