Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

What version of Power BI Desktop do you use? Could you please post the SQL script that you use to create these tables so that I can test? 

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi again

 

Both tables are in Mart Schema in SQL.

 

1. This is the script in Advanced Editor for the one without "Mart"-prefix:

let
    Source = Sql.Database("server", "Financials", [Query="SELECT [mart].[DimVersion].* #(tab)#(tab)FROM [mart].[DimVersion]"]),
    #"Renamed Columns" = Table.RenameColumns(Source, {{"VersionKey", "VersionKey"}, {"VersionName", "VersionName"}, {"Type", "Type"}, {"VersionDate", "VersionDate"}, {"VersionCurrent", "VersionCurrent"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns", {{"VersionKey", Int64.Type}, {"VersionName", type text}, {"Type", type text}, {"VersionDate", type datetime}, {"VersionCurrent", Int64.Type}})
in
    #"Changed Type"

 

2. This is the script in AE for the one with the Mart Prefix:

 

let
    Source = Sql.Database("server", "Financials"),
    mart_DimVendor = Source{[Schema="mart",Item="DimVendor"]}[Data]
in
    mart_DimVendor

 

Does this provide you with any hints?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous

     

    Version number: Version: 2.61.5192.601 64-bit (august 2018)

     

    • mjjuk's avatar
      mjjuk
      Helper I
      7 years ago

      did this ever get resolved??

       

      I am having the same issue - since building a report and creating new measures etc the query has decidedd to remove the table prefix - now the modification steps do not work and if I do chenge them the report once refreshed breaks all the visuals as they are referenceing the "tablename.columnname"