Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
Solved! Go to Solution.
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.
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.