CUB FILE AS DATA SOURCE

[jcaranibar]

Hi,

Is there a way to use a local .CUB (Ms OLAP cube) file as a data source?

I tried but I couldn't connect. However, if I try through Excel (server name in "Connect to Database Server"), there is no problem.

Thanks.

JCA

[v-caliao-msft]

@jcaranibar Based on my research, we cannot use a offline cube (.cub file) as the data source in Power BI desktop. In your scenario, you can connect to your SQL Server Analysis Services database directly. To connect to an SSAS MD database, select Get Data > Database > SQL Server Analysis Services Database
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Charlie Liao