Solved

Power BI dataset as data source

  • 28 November 2023
  • 3 replies
  • 50 views

Userlevel 3
Badge +1

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

icon

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.

Reply