SCSM 2012R2 Data warehouse cubes

[mirage3000]

Hi, when I'm trying to access data warehouse cube with PowerBI I'm getting an error for which I just don't know what to do. The same thing happens in Excel when I choose option Get data. The only way I can make it work is by creating connection in Excel but I need PowerBI. 

I've selected Get data - Analysis services, typed the name of the server and its instance and chose Import option. After that I can see all of the cubes but when I choose to browse them and select particular dimensions and measures to import, this error shows up:

AnalysisServices: Internal error: An unexpected error occured (file 'mddiscovermd.cpp', line 230, function 'MDDiscoverMD::SerializeRowToXML'). 

Can someone help me to better understand why is this happening?

Data warehouse is actually part of System Center Service Manager 2012R2.

[Eric_Zhang]

---

@mirage3000 wrote:

Hi, when I'm trying to access data warehouse cube with PowerBI I'm getting an error for which I just don't know what to do. The same thing happens in Excel when I choose option Get data. The only way I can make it work is by creating connection in Excel but I need PowerBI. 

I've selected Get data - Analysis services, typed the name of the server and its instance and chose Import option. After that I can see all of the cubes but when I choose to browse them and select particular dimensions and measures to import, this error shows up:

AnalysisServices: Internal error: An unexpected error occured (file 'mddiscovermd.cpp', line 230, function 'MDDiscoverMD::SerializeRowToXML'). 

Can someone help me to better understand why is this happening?

Data warehouse is actually part of System Center Service Manager 2012R2.

---

@mirage3000

Please download the latest Power BI Destkop. If the error persists, for better support, you can create a support ticket on Power BI Support page.