Skip to main content

Power BI

Needs Votes

Dataflows: Refactor suggestion to remove columns for warning “complex types cannot be loaded”

Vote (1) Share
's profile image

on 16 Dec 2018 07:56:09

As a user, when I import a table from a sql database which has a foreign key to another table, the UI automagically adds additional columns of datatype “table” for the user to easily join to those tables and add other data to the common query.

In dataflows these are sometimes inconvenient. A capability in the product to one click remove these columns from the query would be useful.