Skip to main content
Microsoft Idea

Power BI

Needs Votes

Option to not prepend tables with schema name

Vote (1) Share
Greg Low's profile image

Greg Low on 10 Jul 2019 10:56:36

When tables are imported from SQL Server databases, schemas are treated inconsistently. dbo is not prepended to the imported table name but other schemas are.

I understand that the same table name might exist in multiple schemas but for those of us who would never do this, we are back to having to rename every single table that's imported.

Please give us an option to avoid that. Something like "add schema name only where duplicate table names exist".

Try to import WideWorldImporters (SQL Server sample database) to see what I mean.