Power BI
Needs VotesRemove schema name (or keep it optionally) importing tables or views from SQL Server
Marco Russo on 19 Feb 2015 07:59:09
When you import tables or views from SQL Server, the schema name is placed before the table/view name. When you import several tables/views from the same schema, this is really useless. Having the option to keep the schema name only on-demand during the import would be very useful.
- Comments (6)
RE: Remove schema name (or keep it optionally) importing tables or views from SQL Server
Good information, thankssehackear.top
RE: Remove schema name (or keep it optionally) importing tables or views from SQL Server
It is a pain to remove schema name from all views manually.There is no use for having the schema names prefixed.
RE: Remove schema name (or keep it optionally) importing tables or views from SQL Server
I think it is even worse when importing from SSAS. We imported a Calendar table and now we have columns named like [Calendar. Calendar Date], while the full column reference is actually 'Calendar'[Calendar. Calendar Date], at least it is obvious this column comes from the Calendar table :)).
RE: Remove schema name (or keep it optionally) importing tables or views from SQL Server
Having the schema name in front of the table takes unnecessary space from the Power BI authoring canvas and makes it difficult to read table names.
Definitely very helpful. Please add.
RE: Remove schema name (or keep it optionally) importing tables or views from SQL Server
We would like to use a layer of database views in a "PowerBI" schema to grant users access to our fact and dimension tables. This is a nice way to insulate users from the underlying tables, and simplifies permissions because we simply grant SELECT and VIEW DEFINITION to the PowerBI schema. It would be very useful if we could automatically prevent Power BI Desktop from including the schema name by default.
RE: Remove schema name (or keep it optionally) importing tables or views from SQL Server
This is so important. Please consider it. For enterprise clients, we use schemas as a security boundary, and I believe that best practice for Power BI is to separate out the views/procs that Power BI accesses into a separate schema with just SELECT and EXECUTE permission for the account that Power BI connects from. That all gets messed up when every time you import a set of views, etc. it prepends the schema name. That makes us have to rename every single one.