Forum Discussion

CAPSTALKER's avatar
CAPSTALKER
Helper I
7 years ago
Solved

Whole database imported into one table

I'm connecting to SQL Server database. I have a weird situation where whole database seems to be imported in one table. Other tables are ok. I'm wondering what makes this behaviour and most of how to...
Need Help
Show and Tell
  • CAPSTALKER's avatar
    CAPSTALKER
    7 years ago

    This got fixed by entering table's Advanced editor. For some reason I had only rows 1 and 2 there:

     

    let
    Source = Sql.Database("SERVER", "db_name"),
    dbo_Target = Source{[Schema="dbo",Item="Goal"]}[Data]          <-- this one was missing

    #"Renamed Columns" = Table.RenameColumns(dbo_Goal,{{...     <-- and this one too

CAPSTALKER's avatar
CAPSTALKER
Helper I
7 years ago

This got fixed by entering table's Advanced editor. For some reason I had only rows 1 and 2 there:

 

let
Source = Sql.Database("SERVER", "db_name"),
dbo_Target = Source{[Schema="dbo",Item="Goal"]}[Data]          <-- this one was missing

#"Renamed Columns" = Table.RenameColumns(dbo_Goal,{{...     <-- and this one too

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, CAPSTALKER 

It's pleasant that your problem has been solved, could you please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.  :smileyvery-happy:

 

Best Regards,

Lin