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
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

      • 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