Forum Discussion

masplin's avatar
masplin
Impactful Individual
9 years ago
Solved

Analyze in Excel open wrong Excel version

I have both excel 2010 and excle 2016 installed as have avery old model I need to refer to.  i have set all the file types od* to Excel 2016 in default programs, but when I do analyze from Power Bi S...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi masplin


    What I would suggest, is to rather download and install the Power BI Publisher for Excel. This is an Add-In that you can install for Excel 2016. And when you have it installed you can then easily connect to your data directly from Excel without having to download the ODC file each time.

     

    Here is the link: https://powerbi.microsoft.com/en-us/excel-dashboard-publisher/

     

    I personally use this option, easier and quicker.

    As well as this should then solve your Excel opening in the wrong version issue.

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi masplin

 

I did test what you are looking to do in Excel and I got the following below, which looks exactly like a table, but it is coming directly from the dataset in the Power BI Service. As you can see below it does have the cube formula's

 

 

 

masplin's avatar
masplin
Impactful Individual
9 years ago

so connect to the dataset, but then add cube formulae in a fresh sheet?  I've never used cube formula so wil lgive that a try.

 

Someone else asked a siilar question nand seems you can use analyze in excel and then use the old pivot table double click and then paste in the dax code as i used to.  i need ot try that out as well

 

Desktop/How-to-export-some-huge-query-results-in-excel/m-p/201684#M88752