Forum Discussion

zootsuitryan's avatar
zootsuitryan
Frequent Visitor
10 years ago
Solved

Analyze in Excel - No Data Fields in Olap Cube

Hi All,   When attempting to analyze my data model in Excel 2010 on my work network I receive the error 'No Data Fields Available in the Olap Cube'. The model was was created with SQL data and load...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi zootsuitryan the reason would be that by design of Power BI  / Analysis Services you need to create or have a calculated measure defined in order to view your data with a measure.

     

    This has been like this in Analysis Services OLAP and Tabular for quite some time, and I am going to assume that the Power BI version is based on the Tabular version. 

     

    I hope that helps clarify things.

     

    And that finally you simply have to create a measure or multiple measures in order to interact with your Power BI Model using the Analyze in Excel feature.

ascendbi's avatar
ascendbi
Icon for Advocate II rankAdvocate II
10 years ago

Hi -

 

You mention the Power BI Tab in Excel (AKA Power BI Publisher for Excel Add-in).  Can you confirm you have the latest version of ? 2.37.3272.24642 that I am aware of. We have noticed issues when older version are used.

 

I can confirm that the Add-in does work with Analyze in Excel with Office 2010 32 and 64 bit - we have many users on it.

 

For testing, instead of a "pull down" with Power BI Add-in > Connect To, can you install the Analyze in Excel (ODC) files and perfom a "push down" to excel (you have do download a .odc connection file) and see how that works?

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/

 

Note: I don't like the ODC experience or option - now that Power BI Publisher offers the same capability,w e have completely removed the SQL Server 2016 SQL_AS_OLEDB.msi from our environment. (Originally the only way for AiX to work). If there is some feature it offers, we havenot discovered it yet.

 

One last note - you are using DAX to create the Measure, correct? The auto-aggregation feature of Power BI does not translate to AiX: http://community.powerbi.com/t5/Service/Analyze-in-Excel-of-Azure-Entreprise-dataset-No-measures/m-p/66762#M12910

 

David

zootsuitryan's avatar
zootsuitryan
Frequent Visitor
10 years ago

Hi David,

 

Thanks for your reply.

 

Yes it is the Publisher Add-in and I have version 2.37.3272.24642.

 

I do already have the Analyze in Excel updates installed and I receive the 'No Data Fields in OLAP Cube' error when I download the ODC file and attempt to open it in Excel.

 

I actually haven't created any measures in the dataset yet. I have joined tables in the model in Power BI but want to establish that I can connect to the model before I build it out.

 

Any thoughts?

 

Thanks!

 

Ryan