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

 

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI Thiyagu,

         

        Have you enable any custom functions in query editor? It may caused the issue.(I test to publish pbix file which get data from excel and host on sharepoint online site without any issues)

         

        Regards,
        Xiaoxin Sheng