Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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=7010a...) but some steps should be missed because I have the same or almost the same problems with Azure...
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'
Hi,
How did you do it? Thanks.
1) This is a bug in AS for Visual Studio. Make sure you download the latest version: https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProj... 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... 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |