The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 delete this table and force it to read correct table? On the SQL Server everythings ok, I know this because other pbix's work fine.
Solved! Go to Solution.
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
hi, @CAPSTALKER
I think when you get data from SQL server, you select the whole database to load instead of select the tables to load.
For example:
And here is a blog for you refer to.
Best Regards,
Lin
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
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.
Best Regards,
Lin
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |