Hi,
Has anyone used a Power BI dataset as a data source? I have tried using the CData SSAS connector but can not get it to work. Any advice would be appreciated.
Best,
//Pontus
Best answer by Christian Hauggaard
View originalHi,
Has anyone used a Power BI dataset as a data source? I have tried using the CData SSAS connector but can not get it to work. Any advice would be appreciated.
Best,
//Pontus
Best answer by Christian Hauggaard
View originalI’ve also tried a bit with the Any source OLE DB, but with no success.
Hi
Please try the Microsoft Power BI XMLA 2023 Provider with the below settings. Please note this requires premium license/workspaces. Documentation for the provider can be found here.
Hi
Thanks! I have no idea how I missed that one. The Any Source OLE DB did work in the end, but only with the use of custom query tables.
I will try the Power BI XMLA 2023 connector and let you know how it goes.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.