Forum Discussion
Anonymous
7 years agoNot applicable
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...
Anonymous
7 years agoNot applicable
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,
Lydia
Anonymous
7 years agoNot applicable
Hi 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?