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 configure both Gateway Connection and Data Source Credentials. I am unfortunately not able to achieve my goal since when trying to map the SQL Server data to its gateway the option Apply is grayed out.
When trying to change the Data Source Credentials instead I was able to change the sharepoint list credentials to OAuth2 but not the SQL Data that doesn't allow this Authentication Method, and when trying with the other 2 "Basic" or "Windows without impersonation" the system is constantly loading
I tried to follow this documentation without success.
Merge or append on-premises and cloud data sources - Power BI | Microsoft Learn
Am I missing something? Please help
Thank you in advance