Comments (9)
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?
from daxstudio.
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?
from daxstudio.
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:
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
from daxstudio.
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:
from daxstudio.
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?)
from daxstudio.
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.
from daxstudio.
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
from daxstudio.
I'll give that a try. Thanks
from daxstudio.
That seems to work very well and easy with Tabular Editor.
Marco, Darren thank you very much! You guys saved my life
from daxstudio.
Related Issues (20)
- Features Request: RDL Support HOT 2
- DaxFormatter.com Error
- Using DAX Studio for first time- need help with connecting HOT 2
- Dax Studio 3.0.11 - Windows 10 - Lockdown Enterprise Laptop "Could not load file or assembly 'DaxStudio.SqlFormatter' ... The system cannot find the file specified HOT 5
- Power BI Easy option to make model case sensitive in DAX Studio HOT 1
- Dax studio HOT 3
- View Metrics admin access issue | XMLA connection - Datamart's semantic model HOT 3
- CTRL + Backspace should put the cursor at the start of the current line HOT 3
- Server Timings and Query Plan only work once HOT 1
- Very minor correction in Writing DAX Queries documentation HOT 1
- Log function for EVALUATE HOT 3
- Formatting a measure output negates a retrieval of a filter for ",Not(ISBLANK( {measure with missing values} ))}" HOT 1
- dax studio not accepting short server address HOT 3
- Load Perf Data export icon doesn't work HOT 6
- Format Query Option: One Line HOT 4
- Cannot connect to SSAS tabular DB: Error connecting: No such host is know HOT 1
- DMV for Calculated Table Expression
- "View As" Does Not Work Properly when Connected to a Power BI XMLA Endpoint HOT 1
- Incorrect Total Time in bottom right side HOT 7
- Excel Add-in does not appear HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from daxstudio.