Forum Discussion

LogicoCR's avatar
LogicoCR
Regular Visitor
8 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
    8 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.

     

     

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

Hi LogicoCR,

In Power Bi service, please right the dataset->schedule refresh->Data source credentials, and check Data source credentials is connect successfully as Ormesome said.

Best Regards,
Angelia

LogicoCR's avatar
LogicoCR
Regular Visitor
8 years ago

Thank you for your reply Angelia!

I am not sure if I am doing this as you said, but in powerbi.com I went to the Dataset, Schedule Refresh but there are no Data Source Credentials in there.

See attachment.