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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

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 May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!