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,

 

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

    • Thiyagu's avatar
      Thiyagu
      Helper III
      8 years ago

      Hi Anonymous

       

      No i didnt enable any custom function.. Could you share your mail id.. I will share my pbix file maybe it will help

       

      Thanks,

      Thiyaga

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Thiyagu,

         

        Did you connect to other data source in excel file?

         

        Regards,

        Xiaoxin Sheng