12-05-2018 05:51 AM
Is there any row limit to fetch data in power bi from sharepoint.
which one is the best connection for sharepoint in power bi.
b. SharePoint Online List
c. SharePoint List
d. SharePoint folder
12-05-2018 09:45 PM
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: https://docs.microsoft.com/en-us/power-bi/service-admin-manage-your-data-storage-in-power-bi#dataset...
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.