datasource: sharepoint list Power BI desktop use sharepoint online list 2.0 to get the data. When sharepoint list itmes over than 5000. the power bi couldn't refresh. as below error Web.Con...
Anonymous Anonymous MS Support called me today that stated this is sharepoint list limited issue so currently there is no way to fix it. looks like sharepoint online list 1.0 connector is the only option for Power BI refresh data over 5K items.