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...
Need Help
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

      • Thiyagu's avatar
        Thiyagu
        Helper III
        8 years ago

        Hi Anonymous

         

        Source is Web and give sharepoint excel file link like https://share.organizationname.com/:x:/r/sites/fffff/Shared Documents/AAA/Source - PBI.xlsx

         

        Credentials type is organization account

         I can able to refresh in my local desktop.. but in service i dont see credential type organizational

         

         

        Please advise to make it works.

         

        Thanks