cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
charlottebail3y
Regular Visitor

Error: The column '' of the table wasn't found.

Hi, 

 

I am replacing the source of my SQL table with a SQL view that contains all of the same columns. Power BI is erroring saying that columns are missing. 

 

These missing columns are table structured columns - not present in the SQL table itself. 

 

How do I connect my new view whilst retaining the table structured columns?

 

Thanks!

Charlotte 🙂

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

My understanding is that those structured columns you see in Power Query are generated based on the primary key and foreign key relationships that exist on the SQL server. If you connect to a view, you lose them since a view is basically just a query rather than an actual table.

 

I don't think there's a way to retain those structured columns but you can still do the necessary joins to get what you need more manually rather than relying on the query editor to automatically detect them.

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

My understanding is that those structured columns you see in Power Query are generated based on the primary key and foreign key relationships that exist on the SQL server. If you connect to a view, you lose them since a view is basically just a query rather than an actual table.

 

I don't think there's a way to retain those structured columns but you can still do the necessary joins to get what you need more manually rather than relying on the query editor to automatically detect them.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors