topic Re: Calculation group VS2017 & TabularEditor in DAX Commands and Tips

Calculation group VS2017 & TabularEditor

Anonymous — Sun, 26 Apr 2020 12:46:21 GMT

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 connected VS2017 to my AdventureWorks Source but when i try to create a calculation group ... VS failed -> Here the error : https://www.youtube.com/watch?v=V5-S2Np8aBk.

2) With another approach, I load my model "MytestTabularModel" (deploy before with VS2017) with Tabular Editor. No problem to create a Calculation Groups, however differents errors appear when i refresh this deployed model ("myTestTabularEditor "):
https://www.youtube.com/watch?v=K-4CpxtqkFU.

") In the third step, I load "myTestTabularEditor" with VS2017 to refresh data and I deploy the model (Do you have an other solutions to load Data in this model ?) -> VS seems to be OK to support the calculation groups but alwaiys impossible to create a calculation group : https://www.youtube.com/ watch? v = TvAvOo1UCXI.

4) The last step is to test my PowerBi Desktop, just to consume Calculation group -> Import mode does not work (https://www.youtube.com/watch?v=kN0fRTNWQ7k) ... There is only Direct Query mode, Why only Direct Query work ?

For my part, this Direct Query mode is complicated just to test new Calculation Group because there is no accessibles formats.
https://www.youtube.com/watch?v=v2OBSgzbbk4.

Can you give me the exact procedure to finally inject the calculation groups in PowerBI Desktop in Import Mode.

Do you make a special link in my Tabular model between Tables and Calculation Table which contain Group ?

Thanks for your helps

Note that i use :

SQL server 15.0.4033.1

Analysis service 15.0.34.14

Tabular Editor 2.9.7

Only Power BI Desktop.

I also tested with Azure as the Pluralsight course (https://app.pluralsight.com/library/courses/building-tabular-models-ssas/table-of-contents?aid=7010a000001xAKZAA2) but some steps should be missed because I have the same or almost the same problems with Azure...

Re: Calculation group VS2017 & TabularEditor

dotykier — Mon, 27 Apr 2020 08:21:40 GMT

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 ProBIToolsFeedback@microsoft.com

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.

Re: Calculation group VS2017 & TabularEditor

sistema — Wed, 07 Apr 2021 11:35:56 GMT

Hello, managed to solve the problem mentioned in the item, where you have the error: "failed to save changes to the server. Error returned: 'Table' Calculationgroup 1 'contains column' CalculationItemColumn 1 'with invalid data type or source column. this column's data type must be string and source column must be 'Name'

Re: Calculation group VS2017 & TabularEditor

gthought — Mon, 02 Jan 2023 12:00:46 GMT

Hi,

How did you do it? Thanks.