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.

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!