Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Why does ODBC connection in PowerBI need password while excel doesn't?

Hi,

 

For some security issues, we could not reveal the db username and password to the end users, so we wrote a small app that adds odbc registry.

 

It works fine in excel without prompting the user for the credentials. But when in PowerBI ,it will require the password. Why is that? Are there any workarounds that would avoid this behavior?

Need Help

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    It seems to me that it should be related to the security whin Power BI service(when a pbix file is published to service, which is different from Excel). And as far as I know, there isn't an option to avoid this behavior currently. :smileyhappy:

     

    Regards