Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.