Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculation group VS2017 & TabularEditor

Hello, I start with SSAS and Calculation Group. I encounter a lot of problem and here is my approach. For this I posted differents videos.  Lets me knows your comments, Please ! 1) First, I connec...
"Calculation Group"
dotykier's avatar
dotykier
Icon for Advocate I rankAdvocate I
6 years ago

1) This is a bug in AS for Visual Studio. Make sure you download the latest version: https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects if the issue persists, contact [email protected]

 

2) This is a bug in SSMS. Make sure you download the latest version: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 If the issue persists, try to perform the refresh using a TMSL/XMLA script instead.

 

3) I would always use SSMS for refreshing - it should work once you download the latest version.

 

4) You can't use calc groups when loading data from Analysis Services in Import/DirectQuery mode. Instead, you have to create a Live Connection to Analysis Services - this is only possible when there are no other data sources in your PBIX file. So create a new PBIX and connect it to Analysis Services as the very first thing you do - then you should be able to consume the calc groups.