Forum Discussion

Sannat's avatar
Sannat
Helper I
2 years ago

Credentials issue

Hi everyone,

I’m really hoping someone can point me in the right direction here.  Connection is via dataflow from Dynamics 365 but I’m having a credentials issue that I can’t seem to resolve.  Hoping I’m missing something obvious.

At first credentials are greyed out until I open desktop, then it becomes visible and I can see the second screenshot:

 

At first credentials are greyed out until I open desktop, then it becomes visible and I see this:

 

  1. For the first credentials issue it is telling me to remove the https:// from the server name format as it isn’t valid even though this has been working fine for some time.  Do I need to do this and if so where can I change it?
  2. For the second credentials issue I get this message:  Failed to updated data source credentials: MS SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server.  The server was not found or was not accessible.  Verify that the instance name is correct and that SQL Server is configured to allow remote connections.  error: 40 

The first set of credentials are fine and connected in the same way via the same URL.  Desktop and system refreshes are successful. I’ve cleared the cache in desktop via options and signed in again via service.

Hoping someone help with the confusion please? Really appreciate any help. Thanks

Dataflow
Need Help

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi Sannat 

     

    What happens if you had to connect to the data directly in Power BI desktop instead of the dataflow does that refresh successfully?

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    2 years ago

    Sannat 

    The 2 things I try for this would be:
    1) Delete this completely from service and republish this again and see if this works.
    2) The SQL error generally points that the SQL server does not allow outbound connections (whitelisting the service IPs might be needed).

     

      

    • Sannat's avatar
      Sannat
      Helper I
      2 years ago

      Thanks for your response, the credentials are for my raw data connection to Dynamics 365, not for a report, would 1. work?

       

      For 2, the odd thing is it's using this connection for the Dataflow. 

       

      For the first screenshot, it's asking me to remove the https:// but I can't seem to see where I can edit this as all sources for data in direct query point to the dataflow. 

       

      • Sannat's avatar
        Sannat
        Helper I
        2 years ago

        Morning, everything is refreshing as normal anyway, I can't identify what the two credential issues are referring to.