![]() Over time Power Query had accumulated many configuration options – which were scattered across the user interface. Which means from the point of view of data crunching, all powerful facilities are available in the Public edition as well. Of course, Power BI integration is not possible. This is ok because for personal use or smaller business usage, these sources are probably not available anyway. Most sophisticated data sources like databases other than SQL Server, HDFS, SharePoint, SAP, etc. Important differences and new features are discussed in this article. Professional editions of Excel 2013 (Pro Plus, Office 365 version) get full power of Power Query – called Premium edition of Power Query.Īll the details about what is different are given here. What is requiredĮxcel 2010 still has to be the Professional Edition to run Power Query.įor Excel 2013, standard version can also use Power Query – it is now called the Public version of Power Query. 64 bit version can use all available RAM – which makes data crunching much faster. Why? Because 32 bit version of Excel can only use 4 GB of RAM – even if your PC has more memory. If you handle large amount of data, it is a good idea to install 64 bit version of Office. Even if your Windows version is 64 bit, Office is usually installed as a 32 bit edition. Remember to choose 32 bit or 64 bit version.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |