Forum Discussion

WW's avatar
WW
Frequent Visitor
10 years ago

Rights on SQL required? Read-only?

Hi All,

 

I am wondering in Power BI desktop, when I connect to SQL source, can I just an account with read-only rights to the SQL? Or will I need read/write access to access to the tables in the database? 

 

Is there any differences?

 

Thanks and Regards, 

Wendy Woo

General Comment
Need Help

3 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    WW when you connect to sql server via power bi desktop you get option to specify windows / sql server credentials. I think read only access should be fine as you're not writing back anything to tables via power bi. 

     

    • WW's avatar
      WW
      Frequent Visitor
      10 years ago

      Thanks for the input! That is my guess as well.

       

      I am doing some trial testing on test servers, I am able to connect. However I am not sure if this impacts the tables that I am seeing. 

      I notice some differences in the tables return when i provide read only or read/write access and I can't have an explanation as to why, or if it might be due to other reasons.

      I am connecting to SCCM-SQL DB to use create some management dashboard. 

       

       

      • v-sihou-msft's avatar
        v-sihou-msft
        Microsoft Employee
        10 years ago

        WW

         

        What's the difference in tables?

         

        Read only and read/write access should reutrn same result when retrieving data. Make sure you connect same data source. If these two different permission are for different login, please check if there's any setting on permission in source table. Also please directly run T-SQL query in source table see if it can return same results.

         

        Regards,