Forum Discussion
table name prefix
Hi
I load all my tables in model from the same SQL DB. In SQL they are all named: "MART.Tablename". When I import the table, in some instances it names the table in Power BI: "Tablename" in other instances (Other tables) it names it "Mart TableName". It seems to be 100% consistent: If I load the same table again it gives it the same name.
We use Cube formula for the model (which have many tables, so it is quite confusing that the naming is not consistent.
Any ideas? Is it a bug, or something we can change?
7 Replies
When you create a query in Power BI, you get to name the query, which is what the table will be called in your model. Power BI often picks a name on your behalf when you choose a datasource. If you don't like the names chosen, you can alter the table name as part of the Edit Query step of your importing.
Anonymous,
In which view or situation do you see the "Tablename" format in Power BI Desktop? Based on my test, when you import tables under MART schema into Power BI, all tables will be named as Mart TableName. If you import tables under dbo schema, all tables will be named as TableName.
Regards,
LydiaHi Lydia
Unfortunately it is not the case in this instance. Since I wrote yesterday, I have tested it by loading the same table in my current model and in a new blank model. In the former case it names it without "Mart" and in the latter case it uses "Mart" as prefix.
According to my client there haven't been any changes in the SQL setup. So it seems strange? Any idea to what can be wrong?