PowerBI supports pulling data from SharePoint lists but only from the default view. My business has tons of views set up. We need to use those views directly in PowerBI
Agreed, also the view could be filtered on an indexed column so that Power BI gets only the requested under 5k list items where the full list might hold 50k o rmore. And the view can exclude the calculated columns and excess workflow columns that hit other restrictions.
