Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Data source credential keep forgetting my entries

Hello friends, My model has 13 Data sources published in service. 8 - OData 5 - Simple Excel files in OneDrive for Business (Web) I went one-by-one and entered the credentials (Odata - Basic, Web...
Need Help
Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Cool Dude,

 

We can do one thing before going to your problem. 

 

Can u please check with Test connection in Manage Gateway.

 

 

 

Try this and let me know .

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I go to Manage Gateways and it says:

    "You don't have any data gateways" - that's because I don't.

    No "test connection" option

     

    My sources are OData and Web (= Excel.Workbook(Web.Contents("https://.....) - no need for Gateway

     

    Some times, very rarely it works, but mostly it keeps forgetting the credentials for some of the sources randomly

     

    Please help

    Thanks

    Michael

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Happy New Year everyone!

       

      Please, I need your help!

       

      The Power BI project is in danger being cancelled by the client because of the refresh that is not working.

      It just feels like a bug that could be fixed.

      Microsoft team, anybody, please help!

       

      Thanks,

      Michael

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

        I have ever got the similar issue that authentication method is reset to Anonymous, however, this behavior doesn’t impact the refresh of dataset in Power BI Service.

        In your scenario, what is the OData data source?  Ensure that the authentication method your used in Power BI Service is same as that you used in Power BI Desktop.

        Besides, as far as I know, the above error can also occur during the refresh process if we pull large data from OData data source. Could you please create a single dataset that only pull limited records from OData data source(for example, 100 records or 1000 records), then publish the dataset to Power BI Service and check if the refresh fails?

        Thanks,
        Lydia Zhang