Forum Discussion

DavidPorTodos's avatar
DavidPorTodos
Advocate I
3 years ago
Solved

Sharepoint online and SQL data Data sources - Issue configuring Data Source Credentials and Gateway

Hi, I have a report using data from Sharepoint online and SQL Server. It works locally perfectly but when Published it doesn't allow to configure the "Schedule Refresh" since I would need first to c...
Need Help
  • DavidPorTodos's avatar
    DavidPorTodos
    3 years ago

    Hi, my issue was seemingly trivial.

    I already did anything explained on the Microsoft documentation.

    Finally, I had to first change the data source credentails for my Sharepoint List to the OAuth2. I was then able to map the SQL server data to its Gateway under Gateway connection. The grayed out "Apply" button was finally available for clicking.

    Thanks anyway

DavidPorTodos's avatar
DavidPorTodos
Advocate I
3 years ago

Hi, my issue was seemingly trivial.

I already did anything explained on the Microsoft documentation.

Finally, I had to first change the data source credentails for my Sharepoint List to the OAuth2. I was then able to map the SQL server data to its Gateway under Gateway connection. The grayed out "Apply" button was finally available for clicking.

Thanks anyway