Forum Discussion

ytangbi's avatar
ytangbi
New Member
8 years ago
Solved

Columns missing with some users even after granting these users with db_owner access

I have same issue with     I have a group with datareader only  access to a SQL DB. When the user uses SSMS they can see all the columns in the product table but when they connect via Power BI Desk...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi ytangbi,

     

    Based on my test in the same desktop version, after grant the user view definition permission(use databasename; grant view definition to username), the user can view the all columns in the table. 

     

    In your scenario, please open Data source settings, check which credential you are using, then make sure you are granting the correct user. After you grant the user, please restart the Power BI desktop, then try again. 

     

     

     

    Best Regards,
    Qiuyun Yu 

  • ytangbi's avatar
    ytangbi
    8 years ago

    Thank you Qiuyun!

     

    The user said he was okay now.

    The best regards,

     

    Yuqng Tang

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi ytangbi,

 

Based on my test in the same desktop version, after grant the user view definition permission(use databasename; grant view definition to username), the user can view the all columns in the table. 

 

In your scenario, please open Data source settings, check which credential you are using, then make sure you are granting the correct user. After you grant the user, please restart the Power BI desktop, then try again. 

 

 

 

Best Regards,
Qiuyun Yu