Forum Discussion
SQL and SharePonit Online List Refresh
Hi,
I have a pbix with data from sql server and SP Online list. I could refresh data in desktop. How can I refresh data in service? I have a gateway already.
Thank you in advance!
Hi misaki233 ,
Have you check Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster option?
and add the sharepoint data source to gateway settings. For more details, please refer to https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#accessing-on-premises-and-cloud-sources-in-the-same-source-query
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
1 Reply
Hi misaki233 ,
Have you check Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster option?
and add the sharepoint data source to gateway settings. For more details, please refer to https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#accessing-on-premises-and-cloud-sources-in-the-same-source-query
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai