Showing results for 
Search instead for 
Did you mean: 
Vikram1 Frequent Visitor
Frequent Visitor

Is there any row limit to fetch data in power bi from sharepoint

Is there any row limit to fetch data in power bi from sharepoint.

which one is the best connection for sharepoint in power bi.

a. ODataFeed

b. SharePoint Online List

c. SharePoint List

d. SharePoint folder

Moderator v-qiuyu-msft

Re: Is there any row limit to fetch data in power bi from sharepoint

Hi @Vikram1,


There is no limitation about how large amount of data imported into Power BI desktop. However, there is a 1 GB limit of pbix file that can be published to Power BI service:


If you want to get data from the SharePoint lists, you can use SharePoint Online List (SPO) or SharePoint List( SP on-premise). If you want to get data from files stored in SharePoint, you can use SharePoint folder. 

We can use the ODataFeed connector as long as the target data source provides OData APIs. 


Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 180 members 2,238 guests
Please welcome our newest community members: