Connect Power BI Desktop to .odc file

[webportal]

I have an .odc file that connects to a cube. It opens a pivot table.

It seems it's not possible to connect Power BI to this file directly as seen here, but how do I retrive the server name, database name, user id and password from this file?

[v-cherch-msft]

Hi @webportal

You may try to open it via Text or notepad and check the information in it.

Regards,

Cherie

[webportal]

Hello @v-cherch-msft, thank you for your support.

I did just that, and created a new OLE DB connection using the string found in <odc:ConnectionString>

Then I got the error: