Forum Discussion

nonoliem's avatar
nonoliem
Regular Visitor
9 years ago
Solved

RLS Analyze in Excel

My Power BI doesnot connect to Excell. I've downloade all what is needed. But I've got repeatedly following message: "I cannot find the Olap Cubus" ( its in Dutch because my language is set to Dutch...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    nonoliem

     

    Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later. Please make sure you've installed SP1 upon your Excel 2010. If your data source is part data from a excel file, it should not be the problem. For the detailed steps of using Analyze in Excel, I think you can take a look at this video and official document.

     

    For your another question, you can change source in data source settings, or alter the data source path directly in Query Editor – Advanced Editor.

     

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

nonoliem

 

Based on the message and this troubleshooting document, If you encounter an error that states Can't find OLAP cube model, then the dataset you're trying to access has no data model, and therefore cannot be analyzed in Excel. What is the file from Github?

 

Best Regards,

Herbert