Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Dataflows Sharepoint list errors for lists

There is an inconsistency between Power BI dataflows and Power BI Desktop, when it comes to the 'get data' option.

 

In Power BI Desktop, selecting 'get data' and using the option Sharepoint List, it will load list types that are list and tasks list without a problem. Yet from the exact same source in Power BI dataflows, an error is shown for the tasks list list type, and it refuses to load this data. The common list type list connect fine in dataflows, but tasks lists do not. Power BI Desktop connects both without a problem.

 

The error is: DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)

 

@Greg_Deckler suggested this could be a bug.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Nomis


In Power BI Desktop, selecting 'get data' and using the option Sharepoint List, it will load list types that are list and tasks list without a problem. Yet from the exact same source in Power BI dataflows, an error is shown for the tasks list list type, and it refuses to load this data. The common list type list connect fine in dataflows, but tasks lists do not. Power BI Desktop connects both without a problem.


Would you please share some screenshots to clarify the results both in desktop and dataflow? Do mask sensitive information in screenshots. 

 

Best Regards,
Qiuyun Yu