Forum Discussion
sql server as a datasource, only dbo-tables/views visible
When I want to use data from a sql server database I can only see tables and views which exists in the dbo-schema.
tables and views which exist in another schema are not visible.
Will this be supported in future editions ?
Hi Franky,
interesting. 10k tables are definitely a lot, i do not know how PBI handles that.
Have you tried "crafting" your own connection string without using the "get data" api?
Take your example database and copy the "advanced options" of the connection. It should look a bit like this (please be aware that i used pseudo-code, so it does not fit 100%).
let
Source = Sql.Databases("YOURSERVERNAME.database.windows.net"),
YOURSERVERNAME= Source{[Name="YOURDATABASENAME"]}[Data],
Schema_TableName = YOURDATABASENAME{[Schema="scheme",Item="TableName"]}[Data]
in
Schema_TableNameTry to replace the elements in the string with the elements of the big Navision Database. :)
You could also try using the SQL statement in the "Get Data" box to directly specify the tables and views you want rather than selecting from the list
9 Replies
Are you sure your user credentials are set up correctly in sql server?
I can see all schemas in my database no problem at all
Yes, I use NT-authentication. just like I connect with SSMS. (I make the views with my account)
When I create the same view below dbo-schema I can see it, when I create the view in another schema (that I create) I do not see the view.(I've just downloaded the last version of powerbi desktop.)
Not sure how to resolve that then sorry, as a workaround you could try using ODBC to connect.
