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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi DavidPorTodos 

You can refer to the following suggestion:

You need to add the SQL data source to the gateway first, you can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql#add-a-data-source

After adding the data source to gateway, then upload your datasource to Power BI Service, then set the "Merge or append cloud data source" in gateway, you can refer to the following link:

On-premises data gateway February update is now available | Microsoft Power BI Blog | Microsoft Power BI

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.