Forum Discussion

AJinCA's avatar
AJinCA
New Member
11 years ago

What credentials do I enter to refresh Power BI data set?

I created a data model in Excel 2013 Power Pivot. The data was in a SQL 2000 database. When I tried to connect initially I received an error message: "Failed to connect to the server. SQL Server Nati...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 years ago

Can you post your connection string? Are you using Integrated Security = True or Integrated Security = SSPI? I seem to recall some issues with the first when using .NET OleDB so you may be running into a similar kind of issue.

  • AJinCA's avatar
    AJinCA
    New Member
    11 years ago

    Hi. Thank you for your reply. Here is the connection string:

     

    Data Source=osi-es-acct1;Initial Catalog=OS_Acct_APP;Integrated Security=True;Persist Security Info=False;User ID=ArthurJ

     

    As you can see, Integrated Security  = True. If I recall correctly when I chose the .Net Framework Data Provider for SQL Server the only choices were Integrated Security = True (or False).

     

    Integrated Security  = SSPI only appeared when choosing SQL Server Native Client 11.0, which as I said does not work with SQL 2000 databases. 

     

    The interesting thing is the Configure dialog box that appears in Power BI when I attempt to configure my credentials has a box labeled Options Integrated Security that lists SSPI as the entry, although it is greyed out. Not sure if that has any significance.

     

    Thank you for your help.

     

    Regards

     

    Arthur Jenkins