Forum Discussion

LogicoCR's avatar
LogicoCR
Regular Visitor
9 years ago
Solved

Publishing succeeded, but Power BI needs credentials for the data source

Hello!   Systems and applications related: Power BI, Dynamics 365 FO, Connection Gateway.   Issue: I have created the gateway. It shows online. I added the DataSource and it shows Online. Yet, wh...
  • Ormesome's avatar
    Ormesome
    9 years ago

    I'm sure someone more knowledgeable can correct me if I'm wrong, but by understanding is that the data source will choose a gateway based on the name of the server and the name of the database. In your screenshot I assume that you've deleted the name of the server out of security concerns when posting on the the internet.

     

    Ensure that you're using the actual server name, and not "localhost" or an IP address in the report.

     

     

Ormesome's avatar
Ormesome
Icon for Helper II rankHelper II
9 years ago

I would check first that the server and database name in your connection string in Power BI Desktop match those in the gateway.

Then I would check that the account specified in the gateway has the same database permissions as the account you're using locally.

  • LogicoCR's avatar
    LogicoCR
    Regular Visitor
    9 years ago

    Thank you for your reply Ormesome!

    The database and server are the same. The users were not. I checked and the user I was using on the gateway did not have the correct permissions to the database.

    So I corrected that (I can now connect with that user/pass to the Database using SQL Server Management) and also from Power BI Desktop, I changed the Source Settings of the report so they'll be using the same username/pass as the one I am using at the gateway. 

    After I changed those permissions I was able to Refresh the report in Power BI Desktop but I am still getting the same message when trying to publish it.

    Any other ideas?

    • LogicoCR's avatar
      LogicoCR
      Regular Visitor
      9 years ago

      I think I am missing something.

      Do I have to tell the report to use a specific gateway? If so, where or how do I do that?

      The error message now it is this one

       

      But I have a Gateway configured using same user/pass and server/database.

       

      • Ormesome's avatar
        Ormesome
        Icon for Helper II rankHelper II
        9 years ago

        I'm sure someone more knowledgeable can correct me if I'm wrong, but by understanding is that the data source will choose a gateway based on the name of the server and the name of the database. In your screenshot I assume that you've deleted the name of the server out of security concerns when posting on the the internet.

         

        Ensure that you're using the actual server name, and not "localhost" or an IP address in the report.