Power BI dataset as data source

  • 28 November 2023
  • 3 replies

Userlevel 3
Badge +1


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 answer by Christian Hauggaard 29 November 2023, 03:23

View original

3 replies

Userlevel 3
Badge +1

I’ve also tried a bit with the Any source OLE DB, but with no success.


Userlevel 6
Badge +5

Hi @pontus.berglund 

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.


Userlevel 3
Badge +1

Hi @Christian Hauggaard,

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.