3 พฤษภาคม 2555 1:16
I'm sure you would have come across kind of my bellow situation. Can you give me some idea/tip on how to handle this.
I have an user in my sql system (userA) and having access to 2 schemas (Schema1, Schema2) in a DB. Say for example, schema1 has 50 tables and schema2 has another 50 tables. Now if the user tries to connect to the db from power pivot is there any way he can choose which schema he wants to look and query on, instead of showing all the tables to which he has access..
- แก้ไขโดย Arvind.P 3 พฤษภาคม 2555 1:21
3 พฤษภาคม 2555 8:33
In the Table Import wizard of Powerpivot, after giving connection details, he can choose "select from a list of tables and views to choose the data to Import" and in the third screen, he can sort the tables by schema names and he can easily choose only the tables, belonging to a particular schema for his powerpivot data model.
Venkataraman R Be Blessed by Divine
3 พฤษภาคม 2555 11:22
But still the user will see the whole list of tables in the 3rd screen. My problem is, I'm having nearly 800 tables across 7 schema's and certain end user's (sql user account) has access to all the schema's. So, in this case if they want to do a reporting using power pivot on the tables present in a single schema, I'm not seeing an option to view those tables alone. Basically, I'm trying to pass the schema information in the connection string (or a work around for this) so that my list of tables/views from which I can see,pick and choose is narrowed down.
4 พฤษภาคม 2555 5:06Can't he choose "Write a query that will specify the data to import"?
-- This posting is provided "AS IS" with no warranties, and confers no rights
7 พฤษภาคม 2555 17:01
My end users are not that technical.
9 พฤษภาคม 2555 7:17ผู้ดูแล
Currently, there is no build-in feature to let the user tries to choose which schema he wants to look and query on, thanks for your understanding.
TechNet Community Support
- ทำเครื่องหมายเป็นคำตอบโดย Challen FuModerator 11 พฤษภาคม 2555 9:26
9 พฤษภาคม 2555 14:57
please follow the link given here for your reference. May it help you.