THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

PowerPivot Compatibility across versions

There are several versions of PowerPivot available and starting with Excel 2013 there are also several versions of Excel. It is useful to look at the compatibility between the different versions of Excel and PowerPivot available now.

As a general rule when you have a PowerPivot workbook saved with a specific version of PowerPivot:

  • You can upgrade a workbook to a newer version of PowerPivot
  • You can upgrade a workbook to a newer version of Excel
  • You cannot open a workbook using a previous version of PowerPivot
  • You cannot open a workbook using a previous version of Excel, if it contains PowerPivot data

First caveat: you can open an Excel 2010 workbook containing a PowerPivot data model in Excel 2013, but once you save it in Excel 2013, you can no longer open it in Excel 2010. This is because a different file format for PowerPivot data used by Excel 2013 that cannot be understood by Excel 2010.

Second caveat: A file saved in Excel 2010 with PowerPivot 2012 (RTM or SP1) cannot be opened by an Excel 2010 running PowerPivot 2008 R2.

Each workbook has a compatibility level for PowerPivot data that corresponds to the PowerPivot version used to save the data. Here is the list of currently available compatibility levels:

  • 1050 (2008 R2)
  • 1100 (2012 RTM/SP1)
  • 1103 (Excel 2013)

The following table tells you what happens when you try to open an Excel 2010 file in a certain compatibility level (columns) with a certain version of PowerPivot (rows):




2008 R2


Not Supported

2012 RTM



2012 SP1



++ It is important to call out that it is *not* supported editing 1050 PowerPivot models in the 2012 release – you *have to* upgrade the model to 110x before you can edit/refresh the model.

A detailed list of errors you can have opening different a workbook with a different compatibility level than the current version of PowerPivot you have is available in the article Version compatibility between PowerPivot Data Models in Excel 2010 and Excel 2013. As the article mention, PowerPivot for SharePoint can open PowerPivot workbooks of previous compatibility levels, but in order to upgrade the data on the server (scheduling a data refresh) you need to upgrade the workbook to the newer format.

You have to be careful using PowerPivot in mixed environment, especially when you want to share an Excel file containing PowerPivot data. Once you refresh PowerPivot data, you need to upgrade the compatibility level if you opened the workbook with a newer version of PowerPivot, and once you do that, your colleague with a previous version of PowerPivot can no longer open the same workbook. Saving the file on SharePoint makes it possible to navigate into data, but you need a correspondent or newer version of PowerPivot on SharePoint than that used to save the file.

For these reasons, when we provide the examples for our PowerPivot Workshop and our book for Excel 2010, the sample files are saved with the older version of PowerPivot (2008 R2). Now that we are working on the Excel 2013 version of the book and of the workshop (soon to be available!), we are finally going to release samples using a newer version of Excel and PowerPivot.

Published Monday, January 14, 2013 2:44 PM by Marco Russo (SQLBI)



Chien-sheng Tsai said:

Bought several different PowerPivot books and trying to learn, but have not been too successful.  In spite of the hype and all the books written by so many authors, PowerPivot just does not seem ready for prime time use.  The idea is good, but so many issues, and so much time required to track errors down--almost not worth the trouble--and now find it difficult to trust PowerPivot.  

I am in a learning mode, so not mission critical.  If I were to rely upon PowerPivot to build a real application, it would be problematic.  

So much promise heralded in the books, and such potential, all wasted in the poor execution.  Good thing it is a free add-in.  Very disappointing.  No wonder the other vendors are still doing well.  MS had potential of being # 1 in self-service BI with PPVT, if it worked well.  

I am running Excel 2010 32-bit on Vista 64-bit with 16 GB RAM and Quad-Core CPU, so it is not that my machine is inadequate.    

amount of interest

April 18, 2013 1:22 AM

Marco Russo (SQLBI) said:

Thank you for the feedback.

In order to be useful (for articles and book), can you be more specific about the reasons why you are not successful using PowerPivot?

Is this because of DAX Language, some bug in the product, some limitation in calculation and/or data modeling, ... ?

What do you see in other product that is better in this regards?

Thanks again,


April 18, 2013 3:21 AM

Kuba said:

Hi Marco,

my name is Kuba and I hope you could help me with issues I encounter with Powerpivot. I created a report based on a simple data model. It has a significant amount of data, however I thought it is still acceptable from Powerpivot perspective. The file is around 100MB.

I use a machine with 8 cores and 16 GB of RAM. However, if I start playing with different attributes from data and move them around ROWS, COLUMNS and FILTERS, I end up with Excel eating almost 15GB of RAM. Then, I start receiving strange errors in Powerpivot about expired sessions etc. It seems as if the tool was quite unstable. What I also noticed is that Excel does not release the memory. It does not matter if the report has complex layout and filters or it is as simple as possible - Excel will occupy those 15BB of RAM as long as I reopen the file. Any ideas why it is like that? Is it a memory management bug?



May 17, 2013 5:09 PM

Marco Russo (SQLBI) said:

Kuba, the issue you describe might be related to some measure that materializes data in memory during query. If this is the case, you have some measure in the data model that could be optimized, but it's hard to make such a diagnosis without analyzing the data model in detail.

If the memory raise up also on simple measures such as SUM(table[column]), then the cause could be something else.

In Excel 2013 I observed some instability (and I hope that a Service Pack will be released soon for that) but it's the first time I heard about memory consumption so huge - unless it's caused by some measure.


May 18, 2013 9:18 AM

MerchandisePlanner said:

I am facing problems regarding the stability of the Power pivot that it keep crshing on me & I am loyhe data. many times I have faced the message (Document not saved) & always when I close the power pivot window the whole excel sheets is crashing & the windows asking me to explor the internet to find a solution & every time no solution appears.

I appreciat your support

May 20, 2013 2:25 PM

Marco Russo (SQLBI) said:

Which version crashes? You should open an incident with Microsoft Support for this type of issues in order to get some assistance. I have experienced some instability but more with Excel 2013 than with Excel 2010.


May 20, 2013 2:54 PM

Massimo said:

Hi Marco,

can i open a Excel 2013 file (with a PowerPivot and a PowerView, without Tabular Model) in a Sharepoint 2010 PowerPivot Gallery (with SQL2012)?




May 22, 2013 1:10 PM

Marco Russo (SQLBI) said:

Massimo, you need SharePoint 2013 in order to open an Excel 2013 file with PowerPivot and/or PowerView.


May 22, 2013 3:24 PM

Badrul said:

I agree with one of the above commentators - PowerPivot in Excel 2010 is more like a beta version than the finished product.

My current is that after saving I cannot re-open the same Powerpivot on the same machine. Something to do with having installed SQL Server Express 2012 after Excel 2010 + Powerpivot 32 bit I reckon.

August 20, 2013 2:10 AM

Marco Russo said:

Badrul, this is strange. PowerPivot in Excel 2010 is more stable than in Excel 2013, at least if you use the latest build of the PowerPivot add-in (currently SP1 CU5). If you have a case that you can repro, I suggest you openin an incident with Microsoft support, they usually are able to identify and solve this type of setup issues.

August 20, 2013 2:47 AM

michael vardinghus said:


I have upgrade that goes totally wrong. How can that be ?

I have a powerpivot and before upgrade its connected to "thisworkbookdatamodel"

After accepting upgrade it explodes some of the connections inside powerpivot and make several connections inside excel all connected to same powerpivot pivottable but with weird connection strings.

I have no clue where to look and it seems weird there isnt any info or tool related this. It doesnt seem solid that a file can be this fragile between versions.

September 8, 2013 5:31 PM

Marco Russo (SQLBI) said:

Michael, do you know in which version you saved the file?

In any case, it's better opening an incident with Microsoft support for this type of issues.


September 8, 2013 5:35 PM

Marijke said:

Hi Marco

We have upgraded to Office 2013, specifically for the new features and capabilities in PowerPivot 2013. I am rather disappointed though because upon refreshing data the report doesn't want to save, or give various other error reasons. I find myself having to repair my office 2013 constantly.

Just my 2c worth.

October 16, 2013 3:27 AM

Shane said:

Hi Marco, I've been tasked with creating a powerpivot self serve solution for our organization and I wanted to know if there are any compatibility issues between 32-bit and 64-bit created files as we have multiple people on a combination of both 32-bit and 64-bit platforms

ie. if I create a powerpivot with 32-bit, is someone with 64-bit able to open, use, manipulate the data?

Everyone in the office either runs Windows XP with 32-bit powerpivot,

Windows 7 64-bit with 64-bit powerpivot or Windows 7 32-bit with powerpivot 32-bit

October 18, 2013 9:47 AM

Marco Russo (SQLBI) said:


moving from 32 to 64 bit and from 64 to 32 bit is not an issue (you might have not enough memory available in 32 bit if the workbook saved in 64 bit is very large - where large means an Excel file larger than 250MB). The problem is PowerPivot compatibility between different version of Excel, as described in the blog post.

October 18, 2013 9:57 AM

Shane said:

Thank you very much Marco, appreciate the quick reply.

October 18, 2013 10:22 AM

Des said:

Hi Marco.

I have just come across your Blog in search of solution to an issue with Excel 2013 x64 and Powerpivot in fact I have had the same problem across Excel 2010 and the 2012 addin.

Do you now why the data connections, specifically one is to MSAS Cube on an SQLServer and the other is to a Teradata DB, WILL NOT save the connection passwords. The appearance is that the passwords are saved but when a Refresh is done the password is requested each time .Only  while still in the Data Model will it connect and refresh.

Once loaded up to Sharepoint 2013 it is useless because it can't be refreshed.

Any help would be greatly appreciated.

February 20, 2014 5:31 PM

Alvaro said:

Hi Marco.

First of all, I just wanted to let you know that I've been learning a lot about Power Pivot through out your You-tube tutorials and presentations, thanks for that.

I have been working with power pivot reports successfully with no problems at all, but I got an error message today when I tried to update my Power Pivot file, it said: SQLException64

              Microsoft PowerPivot Engine


Do you have any idea why this happened and how to fix it?

Thanks Marco.    

April 1, 2014 10:22 AM

SimonaP said:

Hi Marco,

I have a very simple question.

Is it possible to schedulate in Office 365 a data refresh (through gateway configuration) for an Excel 2013 power pivot with a SQL Server 2008R2 data source? Or do I necessary have a Sql server 2012? That is: is it possibile to offer the customer an Office 365 Power BI solution without upgrading to SQL 2012?

Thank you very much and many congratulation for your excellant work.


May 12, 2014 6:25 AM

Marco Russo (SQLBI) said:

Hi Simona,

you can schedule a data refresh using SQL Server 2008 R2 as a data source. I'm sure it works with SQL Server 2008 and (if I remember well) also with SQL Server 2005.

Thanks for the nice words!


May 12, 2014 8:10 AM

Emma said:

Hi Marco,

I accessed excel file from another system in my office, saving takes about 10 minutes the file size is 261MB.

August 23, 2014 6:14 AM

Marco Russo (SQLBI) said:

It could be an issued caused by the network speed - have you tried to copy the file locally?

August 23, 2014 10:37 AM

DexterMorgan said:

PowerPivot=Garbage, until the instability and crashes are addressed. Can't change Measure names after-the-fact (if you change a few at once, all measures break with a yellow error icon), too many add-in crashes where the file can't be saved, and you basically have to nuke your installation of Excel-- and this is just after creating some pretty basic things and not really pushing any limits. Maybe in 2 or 3 years after MS stabilizes things, it could be more reliable, and therefore more useful. Right now, though (and this is after 2 YEARS), it still feels very beta. It's one thing for a Google web service to feel beta, but for hardcore business backend data analysis app to feel beta like this, it's pretty unacceptable, IMO..

September 18, 2014 3:21 PM

Marco Russo (SQLBI) said:

Morgan, I wouldn't agree with the definition of garbage :-) (many companies actually use Power Pivot in production), but I agree with the stability issue that affects Excel 2013 version (Excel 2010 seems better).

September 19, 2014 12:49 AM

Nikhil said:

Hi Marco,

My current organization use Microsoft office 2007. Since from my previous organization I m hands on working on power pivot so requested them and got a single desktop licence version of Microsoft Office standard 2010. I have been facing issue in installing the power pivot even after installing the .Net Framework4 and Visual for 2010 but excel is not opening up now. It opened only once and I cud see powerpivot icon in the excel (making me happy just for that moment). I closed the file and opened again but since then excel is just in starting... mode. I have done several uninstall/install process but nothing is helping me.

Can you please help?

September 22, 2014 1:29 AM

Marco Russo (SQLBI) said:

Nikhil, for these setup issues I would suggest you contacting Microsoft Support. They have much more tools to diagnose the issue you have.

Probably there is some conflict on your machine, but it's hard to say what without a detailed analysis.

September 22, 2014 1:55 AM

Alex said:

Hello Marco.

Is it possible to use PowerPivot for Sharepoint2013 with SQL 2008 R@2? Or SQL sevre must be upgraded on SQL 2012? In that case is it possible to use SQL2012 standard edition?


November 18, 2014 2:56 AM

Marco Russo (SQLBI) said:

Alex, you need SQL 2012 or SQL2014 with a Business Intelligence or Enterprise edition. The Standard edition does not have Tabular model for SSAS.

November 18, 2014 2:59 AM

Jay Rich said:

I am trying to connect to a SQL Server 2014 Express install from Power Pivot Excel 2010, but it says that the SQL Server instance doesn't exist.  Shouldn't I be able to make that connection or is there probably some other issue going on?

November 18, 2014 11:38 AM

Marco Russo (SQLBI) said:

Is SQL 2014 Express on the same machine?

November 18, 2014 6:49 PM

Jay Rich said:

Yes it is, I was just curious if you could only connect to SQL 2012 with Excel 2010 or if that was the limitation.

November 20, 2014 3:55 PM

Marco Russo (SQLBI) said:

I don't have a machine to repro - I have Excel 2010 on machines that also have SQL 2012 - so if the problem is some missing driver, I cannot repro. However, if this is the issue, you might try installing OLE DB driver from SQL Server 2012 (search for SQL Server 2012 Feature Pack)

November 20, 2014 4:45 PM

Alex said:


Can you use PowerPivot for SharePoint 2013 with SQL2008R2 to build to upload excel models and reports without using tabular>

November 25, 2014 3:15 AM

Marco Russo (SQLBI) said:

No, you need SQL Server 2012 Business Intelligence or Enterprise edition to implement PowerPivot for SharePoint 2013

November 25, 2014 4:28 AM

Alex said:

But I can upload Excel 2013 files with powerpivot model inside it and share it with another users (internal and external)? Right?

November 28, 2014 8:15 AM

Marco Russo (SQLBI) said:

Yes of course - just Power Pivot for SharePoint will not work with these files.

November 28, 2014 1:42 PM

Jared said:

Hi Marco

Sometimes when opening a file it tells me that Excel was able to open the file by repairing or removing unreadable content, at which point I see that some pivot slicers have been removed. Based on a proposed solution I found, I've saved my file from binary to macro enabled workbook and back to binary, but I'm worried about whether this will be a permanent fix or if it will just recur at some point in the future.

Do you have any insight into the cause of this issue and whether the fix I have tried will actually suffice?



December 7, 2014 10:12 PM

Marco Russo (SQLBI) said:

Jared, I never experienced this issue - I suggest you to post the message in Power Pivot forum on MSDN and/or to open an incident support with Microsoft.

December 8, 2014 1:43 AM

Chris said:

Hi Marco,

Our company has excel 2010 and SharePoint 2013.  I want to use power view and power pivot.  I am confused as what I can install.   I was doing some reading and I believe I can't use power view in SharePoint 2013 cause of the Excel 2010 limitation.  Can you let me know what I can install?



December 8, 2014 8:05 AM

Marco Russo (SQLBI) said:


it is not an ideal situation. You should be able to upload a Power Pivot 2010 document to a SharePoint 2013 Library and then use Power Pivot for SharePoint - but every time your workbook will be upgraded to Excel 2013 by SharePoint, so you will be no longer able to download and edit it without Excel 2013. However, it should work in one-way only, but you have to install Power Pivot for SharePoint too (which requires SharePoint ENterprise + SQL Server 2012/14 Business Intelligence or Enterprise edition for the licenses).


December 8, 2014 8:34 AM

Simon said:

Hi Marco,

Thanks for your great blog. I have created an Excel Sheet in Excel 2010 with Powerpivot add in. My customer can open the file, but get the following error message: "Initalization of the data source failed". I have tried to open the file in Excel 2013 and after upgrading the file, it works fine. Is it probable to assume that my client has an earlier version of powerpivot for 2010 (for example for server 2008 instead of 2010?. We both use 32-bit versions. It can be noted that neither of use any server connections to Sharepoint.

Best regards,


December 8, 2014 9:44 AM

Simon said:

Additional info for my earlier post. My version is 11.0.3000.0 and his is 10.50.4000.0 (that is server 2008 ver) I guess these are not compatible and the solution is for him to install 11.0.3000.0 (that is server 2012 ver)?

BR Simon

December 8, 2014 10:42 AM

Marco Russo (SQLBI) said:

Yes he needs a version 11, version 10.50 cannot open version 11 - you have to upgrade to SQL 2012...

December 8, 2014 11:00 AM

Robyn said:

I would like to thank you for writing the most honest book I have read on power-pivot, I was in entice into upgrading to office 2013, with the understanding that PowerPoint would provide access to millions of rows of data have read "powerpivot for data analyst" and "power bi with excel 2013", what I did not understand or grasp is the fine print that reveals that while you may be able to load a millions rows of data into the powerpivot, power query,myou would not be able to extract said data in any mean full way. Hence drill down is limited to 1000 rows. "Microsoft excel 2013: building data models with powerpivot" was the only book I am across with clearly outline the limitations of powerpivot, regarding drill-through options. Considering office  2010 allowed the customisation of the drill-through into raw data it seems rather odd that excel 2013 does not have this feature. I can only assume it is a marketing decision ?

As a reporting tool excel 2013 is great, but to what would you suggest as a tool that enable one to manipulate data in a meaningful way.  Ie I am able to fully access the transactional data the is reflected in the report. I am not a computer expert by any means, but I have a good understanding of excel and use macro in excel to create reports that support both operational and reporting requirements.

My definition of a good report is one, that managers and expeditors can both work from. For example, we run a outstanding orders and urgency orders are flagged up and expeditors are able click through and chase those orders, hence managers and expeditors work of the same reports.

Kook forward to your response.

Thanks again for you book.

Kind regards


February 4, 2015 8:04 AM

Marco Russo (SQLBI) said:


not sure about what is the question. Excel 2013 has a different architecture and for this reason you have the limitation in drillthrough. I think we'll see something changing with the next release of Excel and the upcoming Power BI - but I would like to get the same answer from Microsoft as you! :)


February 7, 2015 3:19 AM

Martin said:


Thanks for the clarifications. I have a question regarding our setup. We have SharePoint 2013 with PowerPivot working fine. Then we have some collegues running Excel 2010 and some 2013. I'm aware of the ones using 2010 can't open and edit the data model. But shouldn't they be able to connect to the model with excel?

Well, some can I Believe, but for some the "Data link properties"-dialog box opens or when trying to refresh get a error saying they can't connect to the data source.

Do you know what could be missing in their setup?


March 3, 2015 4:39 AM

Marco Russo (SQLBI) said:

Yes it should work.

I suggest you calling Microsoft Support for this type of issues, they have a larger knowledge base and might find the issue quickly.

March 3, 2015 4:55 AM

john said:


is it possible to open a dashboard created in excel 2013 (created with powerpvit and dax formulas) in excel 2010 (that does not have the powerpivot addin?)

March 6, 2015 11:43 AM

Marco Russo (SQLBI) said:

You can open the file and see the numbers of the last save operation, but you cannot refresh the pivot table.

March 6, 2015 11:49 AM

borge said:

Can PowerPivot of Excel 2010 work with SQL Server Express 2014??

July 16, 2015 11:53 PM

Marco Russo (SQLBI) said:

Yes, it is a SQL Server data source.

August 21, 2015 6:30 PM

Pete said:

Hi Marco, now working with an Excel 2013 powerpivot data model connected to a SQL server. Bought your book on this topic which was extremely useful.

Question on setting the connection string extended property with the MDXMissingMemberMode=Ignore, should this work or only with SSAS? Thought Excel communicates with the powerpivot model in MDX so gave it a try but no luck. I want to have my cube formulas avoid erroring out when one dimension member might not exist for good reason. I used this same extended property in a SSAS model with the same cube formulas and it worked just fine.

August 28, 2015 10:38 AM

Marco Russo (SQLBI) said:

Pete, I think you cannot change the connection string for Power Pivot - even if the engine is the same, there are differences in the way it communicates with Excel as embedded engine.

September 15, 2015 5:03 AM

Joe Paredes said:

Hello Marco - I have a PowerPivot file I created using excel 2010 (32bit) and I have uploaded into our company sharepoint 2013 site but when I open the file and try to use the slicers to see if functionality is working I receive an error message. "PivotTable Operation failed. An error occurred while working om the Data Model in the workbook Please try Again" . The SP admin tells me that SP 2013 can open 2010 files but functionality will not be available. Is there a compatibility issue with SP 2013 and excel 2010 PPVT files?


January 8, 2016 2:42 PM

Marco Russo (SQLBI) said:

Joe, you probably have to upgrade the model to Excel 2013 before publishing it in SharePoint 2013 if you want to get all the features. Actually, I thought that an automatic upgrade would have been done by Power Pivot for SharePoint, but as you say, it seems this is not the case.

January 10, 2016 6:14 AM

Joe Paredes said:

Marco - yes the SP admin advised me that file needed to be excel 2013 version in order for powerpivot functionality to work so I sent her the file and she converted file to excel 2013 but still receive same error so not sure if converting file to excel 2013 made a difference.

January 13, 2016 12:45 PM

Marco Russo (SQLBI) said:

This is strange - I suggest you to open an incident support case with Microsoft.

January 14, 2016 4:29 AM

Michael Skelmose said:

Hi Marco, my Company has SharePoint 2013, but I would really like to have some og the new features in Excel 2016, like Boxplots, Waterfall plots, and the new DAX formulas Median and Percentile etc...  Would it be possible for SharePoint 2013 to run PowerPivot models and reports made in Excel 2016? Or would I get compatibility problems?

January 28, 2016 10:22 AM

Will Y said:

Hello Marco, our partner is using excel 2010 to create a pivot table and I am using excel 2013, which could open the file and use the pivot table, but when I refresh it, all data is gone. When check the data resource, the range is still there but they don't reflect on the table anymore.

January 28, 2016 4:34 PM

Marco Russo (SQLBI) said:

Michael: there is a full compatibility of Power Pivot model binary format between 2013 and 2016, but any new feature in 2016 cannot be displayed in 2013. You should expect the same behavior in SharePoint, waiting for SharePoint 2016 if you use some of the new features in Excel 2016.

Will: when you open an Excel 2010 data model in  Excel 2013/2016, you should see a prompt asking you to upgrade the data model. You have to confirm that, and the file has to be saved on a folder (when you open it from an attachment or a zip file, it might not upgrade resulting in what you described).

January 28, 2016 5:10 PM

Raj said:

Excel 2010.Power Pivot window is used to connect to the sql server database and imported number of tables,created pivot charts and saved the work book.

When the work book reopened ,i could not find the power pivot button in the saved work book!

Is there any way to retrieve the model i created

June 30, 2016 6:02 AM

Marco Russo (SQLBI) said:

It seems the result of a crash of Excel. Open Task Manager and see if in process list (tab Details) you still have Excel open, if yes, kill the process. Otherwise you can logoff and logon (or restart) to obtain the same result.

June 30, 2016 6:14 AM

Raj said:

Thanks.It is working now!

June 30, 2016 7:22 AM

Charle said:

Hi Marco,

I am having an issue with the connection. I have created a data model and saved it use the excel UI. Then created an interactive dashboard using tables and charts from power pivot. Now during the refresh process for another user, an error pops up and removed the connection to the data file. This is now removing the data feed to the charts and visual created.

The real reason the data model was created using the EXCEL UI instead of the Power Pivot UI is because the file has beem moved to different locations and the connection string keep breaking.

I am using flat flies currently can am not able to direct connect.

Any suggesion??

July 4, 2016 10:45 PM

Marco Russo (SQLBI) said:

Sorry I am not sure how to help you on this - probably you should ask to Microsoft support if you have a problem like that.

August 17, 2016 10:46 AM

Jall said:

Is PowerPivot for Excel 2013 32 bit compatible with SQL Server 2014 SP2 Enterprise 64bit ?

March 17, 2017 11:19 AM

Marco Russo (SQLBI) said:

It should be!

March 30, 2017 10:33 PM

MOX said:

How or can we get SharePoint 2013 to render a DAX that has the VAR function?

I believe this VAR function new in DAX 2015.  

May 15, 2018 4:20 PM

Marco Russo (SQLBI) said:

You cannot - you should remove the use of VAR from the DAX code.

May 15, 2018 6:53 PM
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement