APIs exposed by SOD are not applying any filter or limitations, other what Business Central does on all API calls (like the 20K record limitation).
Not sure how to help you, I wonder if your Power BI connection is broken somehow, can try creating a new report just to get the data.
After researching the record limitation, I believe it’s related to that. That answers my question, thank you