Forum Discussion

ncbshiva's avatar
ncbshiva
Icon for Advocate V rankAdvocate V
7 years ago

Refresh failed in the Power BI online

Hi Team,   In my report , i am using SharePoint and SQL Datasource and i am using gateway to refresh the data in the SQL . But the refresh is failing with below error message. Not sure why the refr...
Need Help
ncbshiva's avatar
ncbshiva
Icon for Advocate V rankAdvocate V
7 years ago

Hi v-yulgu-msft,

 

I have verified the credentials , it works when i have less number of files in the Sharepoint (like 5 files). But the online refresh fails when the number of files is more than 5 in the SharePoint. And the refresh works fine in the Desktop version regardless of the number of files in the SharePoint.

 

Regards

 

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi ncbshiva,

 

Did you use On-Premises gateway personal mode and choose OAuth2 as authentication type in your scenario?

 

Regards,

Yuliana Gu

  • ncbshiva's avatar
    ncbshiva
    Icon for Advocate V rankAdvocate V
    7 years ago

    Hi v-yulgu-msft,

     

    Please find below screenshot of the gateway that i am using , it is not Personel mode. And i have authenticated with OAuth2 type.

     

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi ncbshiva,

       

      I would suggest you create a support ticket for further analysis, as all configurations looks correct and the scheduled refresh should work.

       

      Regards,

      Yuliana Gu