I need to pull data from hundreds of boards, does Power BI Connector have any limitations?

There are no limitations in that regard. Power BI Connector allows to pull data from all the boards the user has access to.