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,

 

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