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

 

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

v-haibl-msft

 

I think I got the problem.


Power BI
Instellingen

 

 


Gegevens ophalen
Aanbevolen dashboard

Favorieten
Mijn werkruimte


Weergeven:Alle inhoud

Dashboards


Mijn eerste Dashboard
Rapporten

GitHub

Mijn eersterapportpowerBI

PMHsplitdedicatedenergy
Gegevenssets


Financial Sample

GitHub

Mijn eersterapportpowerBI

PMHsplitdedicatedenergy
Streaminggegevenssets

 


Algemeen
Dashboards
Gegevenssets
Werkmappen
Waarschuwingen
Financial Sample
GitHub
Mijn eersterapportpowerBI
PMHsplitdedicatedenergy


Instellingen voor Mijn eersterapportpowerBI

Deze gegevensset bevat een on-premises gegevensbron. Als u de gegevensvernieuwing wilt plannen, kunt u Power BI Pro 60,00 dagen uitproberen. U kunt ook contact opnemen met uw Office 365-tenantbeheerder om Power BI Pro te kopen.
Pro gratis uitproberen
Q&A en Cortana
Aanbevolen Q&A-vragen

I shall translate it for you:

It says that the dataset is a on-premises data source( which is right-excell worksht on my pc). If you want to renew is you can try Power BI Pro for 60 days. etc etc.

 

So it seems I need Power BI Pro to be able to analyze in excell? Strange to me.

The github file doesnot give this message.

 

kind regards

 

Nono Liem

 

 

 

 

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

    nonoliem

     

    Analyze in Excel should can also be used by free users. But if we need to access on-premises data using the Data Connectivity Gateways, pro license is needed. For difference between free and pro license, please refer to this document.

     

    Best Regards,

    Herbert

    • nonoliem's avatar
      nonoliem
      Regular Visitor
      9 years ago

      v-haibl-msft

       

      Many thks again.

       

      I still cannot understand why my BI file cannot find data in the Olap cubus to analyze in excell.

      continue my search to tackle the problem.

       

      Thks so far. Your advises were very helpfull

       

      kind regards

       

      Nono Liem