If you receive a message about disabling this extension, please disregard. If you click “Disable this extension”, Analysis Services projects will no longer load. You will need to re-enable the extensions through Extensions and Updates.
If you'd like to have early access to VS2022 release candidate builds before they are published to the VS Gallery, we’re making available to give customers an opportunity to provide feedback prior to finalizing releases. To access the release candidate of the extensions in Visual Studio, you may do so by creating a “private gallery” and entering the following settings.
Navigate to Tools > Options and then select Extensions and Updates under General.
Under "Additional Extension Galleries", enter the following details:
Name: Microsoft BI VSIX Preview
URL: http://aka.ms/ProBI-VSIX2022
After entering these settings, your "Extensions and Updates" dialog will show updates for the extension when there is a new release candidate that you can install to provide feedback for a day or two before the VS Gallery VSIX is updated.
Provide feedback and report issues with this Vsix Package or Analysis Services modeling projects in general to: ProBIToolsFeedback@microsoft.com.
New in the July 12th, 2021 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.18):
- Fixed an issue where the DAX editor would be disabled occasionally on project load.
- Fixed an issue in Mining Model viewer where the drill through window would be transparent if PMA was enabled.
- Fixed an issue with 1200 compatibility-level tabular models that prevented changing the provider when using Direct Query with Teradata or Oracle as a data source.
- Fixed an issue preventing the use of the Html.Table function in the PQ Query Editor window.
If you encounter any issues with this latest release, you can get the previous release (2.9.17) at https://go.microsoft.com/fwlink/?linkid=2167835
In VS2019, if you experience hangs or crashes, please try clearing your VS component cache (shutdown VS, and delete the %USERPROFILE%\AppData\Local\Microsoft\VisualStudio\16.x_xxxxxxxx\ComponentModelCache folder, then restart VS). Also, there are still known issues with WinForms controls and the Per Monitor Awareness feature in VS2019. While we have addressed a number of these issues, if the tabular measures grid is not painting, please disable this setting: Navigate to Tools in the Menu bar, then click ‘Options’. Next, under the Environment tab click ‘General’ and uncheck the option 'Optimize rendering for screens with different pixel densities'.
New in the March 30th, 2021 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.17):
- Various fixes for error messages and accessibility improvements.
- Fix an issue with Microsoft Narrator reading of the table grid.
- Updated Power Query components to SU02 (February) release.
New in the February 10th, 2021 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.16):
- Fixed an error that occurred while trying to open Tabular models in AS projects while SSIS is installed.
New in the December 9th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.15):
- Adding support for Power BI Premium Gen2 workspaces.
- Fixed an error that occurred when trying to specify a Date column as a row identifier.
New in the October 9th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.14):
- Fixed an issue in tabular projects where users were unable to create new calculation groups while in DirectQuery mode
- Fixed an issue in tabular projects where users were unable to import data from Azure Blob storage
- Fixed an issue in tabular projects where the Advanced Editor in the Power Query designer was disabled
- Fixed an issue in tabular projects where cutting and pasting in the measure grid would cause Visual Studio to crash
- Fixed an issue in tabular projects where clicking Fit to Screen in model diagram layout while viewing a perspective may have caused an unhandled exception
- Fixed an issue in tabular projects the may have prevented the Exchange connector from successfully working when using email address as the user name
- Updated Power Query in tabular projects to the SU08 release
New in the September 8th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.13):
- Updated Power Query components to SU08 (August) release
- Fixed an issue that would prevent a user from deploying AS models to an on-prem domain-joined AS server from an AAD domain-joined machine
- Added warnings to Tabular models perspective dialog to ensure perspectives are created correctly.
- Added Diagnostics mode to SSDT to allow for easier and quicker collection of helpful logs and debug information for customer support
- Fixed an issue with the Exchange Power Query Connector in tabular models which prevented users from establishing a connection to import data from Exchange Online and Exchange OnPrem
- Fixed an issue which prevented users from using the Column by Example feature in the Power Query Editor.
New in the July 24th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.12):
- Fixed an issue in VS2019 where the data grid would not display properly after importing new data when “Optimize rendering for screens with different pixel densities” setting enabled
- Fixed an issue where the deployment dialog would be hidden, blocking users from focusing on Visual Studio.
- Fixed an issue which prevented measures from being edited while in a perspective.
- Added a variety of accessibility improvements to allow for easier navigation in certain controls, as well as more support for screen readers.
- Fixed an issue where opening or creating a new project would not open and raise the error "Can't Open Model.bim file localhost was not found".
New in the May 22nd, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.10):
- Robustness fixes for using the PowerQuery editor when a table has hierarchies defined.
- Fixed an issue that prevented the Schema Generation Wizard from working in Multidimensional projects.
New in the April 30th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.9):
- Fixed an issue where editing an existing Power Query partition in the partition editor caused Visual Studio to crash in some cases.
- Fixed an issue that could lead to an error “Altering referenced object not permitted…” when deploying tabular models with perspectives
New in the April 16th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.8):
- Fixed an issue where the DAX editor would change delimiters incorrectly in some cases for some regional settings.
New in the April 7th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.7):
- Fixed an issue where a null reference exception occurred when opening Script View in the Calculations tab in Multi-Dimensional projects
- Fixed an issue where the DAX editor would change delimiters incorrectly in some cases with some regional settings
- Fixed issues caused by Per Monitor DPI Awareness feature in Visual Studio 2019 not working well with Power Query UI components
- Updated Power Query components to SU03 (March) release
If you encounter any issues with this release, you can get the 2.9.6 release at https://go.microsoft.com/fwlink/?linkid=2122586
New in the March 13th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.6):
- Fixed issue where button may have been unreadable.
- Fixed issue where renaming a hierarchy could rename the incorrect hierarchy.
- Fixed issue where using the command line to build a Multidimensional project with a large amount of roles would fail.
New in the February 4th, 2020 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.5):
- Fixed various High DPI issues in VS2019.
- Fixed issue where the role manager would flash or freeze.
- Fixed error where exploring table data could throw “Could not load file or assembly Microsoft.VisualStudio.DpiAwareness”.
- Fixed error where deploying Multidimensional model could fail with error “Object reference not set to an instance of an object (Microsoft.AnalysisServices.Project.AS)”.
- Fixed issued of object reference not set to instance of object error when deleting a calculated table.
- Fixed issue where opening a project would sometimes throw the error “The item already exists in the collection”
- Fixed issues with the MDX Cube debugger.
- Fixed issues with localization.
- Fixed issue where Role properties dialog would not find new users.
New in the December 11th, 2019 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.4):
- Fixed issues where controls may have been abnormally sized, especially in high DPI situations.
- Fixed issue where deployment dialog in Multidimensional projects would not show correctly in VS2019.
- Fixed issue that may have crashed Visual Studio when moving hierarchies while in diagram view for Tabular Projects.
- Fixed issue that may have crashed Visual Studio when setting calc members in multi-dimensional projects.
- Fixed issue with the DAX auto-complete functionality within the formula bar.
New in the November 1st, 2019 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.3):
- Accessibility improvements for multiple designers
- Added support for MSOLEDBSQL provider
- Fixed issues that may have caused a hang when trying to switching between view tabs in multi-dimensional project designers
- Fixed an issue causing "SSIS Excel Destination Error - No tables or views could be loaded" when configuring the Excel Destination Task in the SSIS Designer when both SSIS and SSAS extensions were installed
- Improved the behavior between the property sheet and selection service in tabular projects when setting properties on some objects
- Fixed an issue in DAX editor\parser when using international list delimiters
- Improved table import performance
New in the October 8th, 2019 Release of Microsoft Analysis Services Projects (VSIX Update 2.9.2):
- Fixed an issue that would prevent being able to open SSIS projects.
- Added support for 1500 compatibility level which includes calculation groups and many to many relationships. More details can be found on the blog post: https://azure.microsoft.com/en-us/updates/ssdt-support-for-1500-compatibility-level/
- Improved performance while editing inside the diagram view.
- Fixed various crashes and hangs.
- Updated PowerQuery components and Mashup engine to SU09
New in the September 20th, 2019 Release of Microsoft Analysis Services Projects (VSIX Update 2.8.19):
- Fixed an issue where editing expressions would throw a nullable object error in Power Query UI in Tabular models.
- Fixed issues related to a regression in .NET 4.8 that causes crashes in Visual Studio.
- Fixed an issue where DAX functions would show syntax errors in the DAX editor.
- Fixed an issue where there was a hang on deployment in Tabular models.
New in the September 12th, 2019 Release of Microsoft Analysis Services Projects (VSIX Update 2.8.18):
- Fixed an issue where trying to get data from an Analysis Services server would throw an "Could not load file or assembly 'Microsoft.PowerBI.AdomdClient'" error.
- Fixed an issue where an AS Connection in SSIS could not connect to Azure Analysis Services.
- Updated PowerQuery components and Mashup engine to SU08 (for 1400 compatibility-level models)
- Added a "Refresh Credential" menu item in 1400 compatibility-level models.
Changes in Previous Releases:
RSS Feed for SSDT
https://blogs.msdn.microsoft.com/ssdt/feed/
Package includes support for Tabular and Multidimensional projects. After creating a new model project by using one of the templates, you can begin model authoring by using the designer tools and wizards included in the chosen project type. Among other things, you can import existing models from a server or from Power Pivot or start a new, blank model project.
Analysis Services modeling projects integrate with source control, such as Team Foundation Server and many third-party source control plug-ins. If you have configured Visual Studio to use source control, you can use check in/check out from Solution Explorer.
Visit https://blogs.msdn.microsoft.com/analysisservices/ for the latest information, tips, news, and announcements about Analysis Services directly from the product team.
Preview Release Candidate Builds
If you'd like to have early access to release candidate builds before they are published to the VS Gallery, we’re making available to give customers an opportunity to provide feedback prior to finalizing releases. To access the release candidate of the extensions in Visual Studio, you may do so by creating a “private gallery” and entering the following settings.
- Navigate to Tools > Options and then select Extensions and Updates under General.
- Under "Additional Extension Galleries", enter the following details:
- Name: Microsoft BI VSIX Preview
- URL: http://aka.ms/ProBI-VSIX
After entering these settings, your "Extensions and Updates" dialog will show updates for the extension when there is a new release candidate that you can install to provide feedback for a day or two before the VS Gallery VSIX is updated.
Provide feedback and report issues with this Vsix Package or Analysis Services modeling projects in general to: ProBIToolsFeedback@microsoft.com.
Installation issues
A small number of users have reported installation issues. If you experience installation issues in either Visual Studio 2019 or 2017 please use the following steps to mitigate the issue:
- Uninstall the Analysis Services Projects extension from both VS 2019 and VS2017 (if you have both installed on the same machine).
a. In VS 2019 navigate to ‘Extensions’ -> ‘Manage Extensions’ -> Find “Microsoft Analysis Services Projects” -> Click ‘Uninstall’
b. In VS 2017 navigate to ‘Tools’ -> ‘Extensions and Updates’ -> Find “Microsoft Analysis Services Projects” -> Click ‘Uninstall’
- Ensure they were successfully uninstalled.
a. Navigate to C:\Program Files (x86)\Microsoft Visual Studio<2019 or 2017><Edition>\Common7\IDE\CommonExtensions\Microsoft
b. If the folder ‘SSAS’ exists, please delete it.
c. Navigate to C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\MSBuild
d. If the folder 'Business Intelligence Semantic Model' exists, please delete it.
- Reinstall the latest extension available on the Visual Studio Marketplace.
