Forum Discussion

QuasemS's avatar
QuasemS
Frequent Visitor
10 years ago

Excel workbook Import error

Hi,   I'm trying to import an Excel Workbook connected to a cube but Power BI tells me it doesn't contain any queries or model to import. Anyone have this problem before?
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi QuasemS,

I can reproduce your issue when connecting to Excel Workbook which contains cube using File ->import->Excel Workbook Contents option in Power BI Desktop.

As a workaround for this issue, you can import Excel Workbook that connects to cube using Get Data-> Excel option in Power BI Desktop.

Thanks,
Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, 

 

Thanks for the reply.

 

I can do this but I was following best practice to create a KPI table not a data set from a Excel spreadsheet.

 

Thanks

S