Forum Discussion

Thiyagu's avatar
Thiyagu
Helper III
8 years ago

Invalid data source credentials for schedule refresh

Hi Team,

 

My PBI report source type is Excel which is placed in Office 365 (Sharepoint). I connected using get data --> web and give the link for my excel file.. In my PBI desktop everything works fine after i gave authentication as "Organizational".

 

Problem starts after i upload that pbi report in one of my organizational workspace. The PBI file also placed as same as source file. Error shows like Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

 

When i try to edit credentials, it shows drop downs for choose Anonymous,Basic&Windows.

 

When i check gateway connection it shows "Connect Directly"

 

What should i do to make my dataset always up to date.

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Thiyagu,

     

    Can you please share more detailed information about your issue?

     

    For example:

    connection mode, data source credentials setting.

     

     

     

    Regards,
    Xiaoxin Sheng

    • Thiyagu's avatar
      Thiyagu
      Helper III
      8 years ago

      Hi Anonymous

       

      Thank you for the response...

       

      Please find the screenshot below,

       

       

       

       

       

    • Thiyagu's avatar
      Thiyagu
      Helper III
      8 years ago

      Hi Anonymous

       

      If any additional information need please let me know.

       

      Thanks,

      Thiyaga

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Thiyagu,

         

        Based on test, I can use oauth credential with excel file who store in sharepoint online.

         

        Can you please provide get data and detail operations steps?

         

        Regards,

        Xiaoxin Sheng