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

nonoliem's avatar
nonoliem
Regular Visitor
9 years ago

@Herbert Liu

 

Thks for reply. I have downloaded a Github file at random just to experience Power BI. I'am a new however enthusiatic user of Power BI. I don't now what kind of file it is. It concerns visualizations of Author contributions to something. Sorry not quite clear. I tried to insert a QR but cannot do it here.

 

My file is based on data extracted from an Excell worksheet ( part of a workbook). Is this the reason? Does it search for a kubus  on a SQL server or something like that? I use Excell 2010(Office 2010 Professional).

 

I'am free to pose another question here:

I noticed that if I move the file where data is extracted from to another location or rename it, Power BI does not follow its path nor the changes. This means that if you want to edit de data model he cannot find it and issue an error.

And probably you also cannot refresh the Pbix. But there is no way you can alter the path etc. so that Power Bi can be on track again. Do I overlook something here?

 

Thks in advance and kind regards

 

Nono Liem