search

DaxStudio / DaxStudio

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Desktop, Power Pivot for Excel, and Analysis Services Tabular.
http://daxstudio.org
Other
677 stars 143 forks source link

Problems connecting to SSAS Tabular 2016 #29

Closed UweMester closed 6 years ago

UweMester commented 6 years ago

Hi, I'am struggeling with connecting the latest version of DAX Studio to my workspace SSAS Tabular database. It seems as if DAX Studio has problems rendering the Metadata-Pane.

Translated error message: "An element with the same key already has been added"

I attached the log file and a screenshot with the translation of the german parts in the log-file:

DaxStudio-20171113.log screenshot log file

It seem as if DAX Studio tries to connect to the same database twice. I have no clue how to resolve this.

Any ideas?

Thanks and regards from germany

Uwe

dgosbell commented 6 years ago

I don't know what would cause this. I can't reproduce this behaviour on any of my local solutions. Does it happen on other solutions or just with this one? Is it possibly to share the .bim file or a version of it?

dgosbell commented 6 years ago

Actually can you even just paste in a list of the table names in your model? Are there any tables which have similar names? Maybe varying by accent or something like that?

UweMester commented 6 years ago

Hey Darren,

unfortunatelly there is no other solution existing at the moment.

Here is a screenshot of the table names in the model and the name the tables have in the DWH from which I'am loading them: table names

I' am using a calculated table in the model which is named "Measures". We are using this for centralized hosting of the measures for the users. It seems as if thats the reason. When I delete it, everything works fine. I guess the term "Measure" is a reserved term in DAX Studio? Should have thought about that from the beginning.

Thanks

dgosbell commented 6 years ago

Yes, the "Measures" table could be the issue. Do you remember how you got that table into your model? I tried creating a calculated table called Measures and I get the following error: image

marcosqlbi commented 6 years ago

The name "Measures" is a reserved word in MDX. You probably have a problem even if you open the model in Excel (do you use Power BI as only client now?)

UweMester commented 6 years ago

Thats strange. I used SSDT 2015 and was just able to create that table with that name without any error messages. The model is productive since nine months now and we are just using Excel as client at the moment. We never had any problems with that model/table or Excel

But now (after deleting the table in the model) when I try to open a copy of the project file still containing that table to rename it, SSDT doesn't open it anymore. It now refuses opening the project with the message that there can't be a table named "Measures", because its a reserved word.

Tried to rename the table in the metadata-file but wasn't successful.

So my problem now is how to rename the table in the project because I don't want to lose all the measures.

marcosqlbi commented 6 years ago

You should do the rename deep in the model. I suggest you trying to edit the BIM file using Tabular Editor: https://github.com/otykier/TabularEditor/releases/tag/2.6

UweMester commented 6 years ago

I'll give that a try. Thanks

UweMester commented 6 years ago

That seems to work very well and easy with Tabular Editor. Marco, Darren thank you very much! You guys saved my life