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...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 years ago

What type of data were you going after? I've had some issues with Power BI's refresh, no doubt. In my case I was going after an Excel file on a network file system. Also had issues with SharePoint Online.

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 !!