Forum Discussion

compkos's avatar
compkos
Frequent Visitor
11 years ago

Login failed on premise data

Login failed. Hide details Activity Id: 59844140-1a4a-4aa5-b82a-9d17e9748a68 Request Id: 891e9cb4-2621-f1d7-00c4-5fa0be5f95ba Status Code: 400 Time: Mon Aug 10 2015 13:59:38 GM...
compkos's avatar
compkos
Frequent Visitor
11 years ago

Thanks for your answer

I have an excel file with 2 data models from power query on sharepoint online onedrive business.

This excel retrive data from an on premise sql server where install succefull microsoft power bi personal getway.

I have set in data connections in excel file authentication settings to none.

When  set username and password fro getway for refresh in power bi  get this message

compkos's avatar
compkos
Frequent Visitor
11 years ago

Also have this in failed log

 

Processing error The credential stored in the cloud is missing

  • andre's avatar
    andre
    Memorable Member
    11 years ago

    you have to re-enter login/password information in the service (it's not enough to have credentials stored in the model).  right click on your data set->schedule refresh->Manage Datasources->edit credentials

    • compkos's avatar
      compkos
      Frequent Visitor
      11 years ago

      Hello

       

      Change the authentication settings in Excel file in Data Connections to Use the authentiicated user's account and looks work fine

      If i have problem again inform you

      Thanks all for your answer !!