More than 1000 Records in Power BI

Hi there! Can anyone help me understand how to handle pagination in Power BI? I can connect to my tables, but I’m limited to 1,000 records, and I don’t know how to loop through my results in a way that allows me to import all records in a table. I would love a little help with this to start leveraging Power BI dashboards.

Thanks in advance!

@Glen please look this article.
https://docs.tadabase.io/categories/manual/article/viewing-data-in-microsoft-bi