Power BI Desktop Queries using functions

hi All

 

I have built a query in Power BI Desktop that uses a function to read out and combine data from multiple SharePoint lists (that have the same structure). When published to Power BI, refresh doesnt work.

 

Error message: The provider 'Microsoft.PowerBI.OleDb' is not registered. The following system error occurred: Class not registered A connection could not be made to the data source with the Name of 'Reporting Entities (2) dd16c57e-fb37-4c81-8125-38050732103c'. The current operation was cancelled because another operation in the transaction failed.

 

The different queries I build work individually and refreshing works as well. However as soon as I turn one of them into a Function, and call that function in another query in order to read out mutliple sources the refresh in Power BI does not work anymore. Any suggestions?