Forum Discussion
Uploading report to Customer Environment
Hi jaryszek,
Thank you for reaching out in Microsoft Community Forum.
Yes, if you have the SQL.Database source set up for refresh (as shown in your screenshot), it will trigger the required gateway credentials on the customer's end. This is because SQL.Database is an on-premises data source, and Power BI needs a gateway to securely connect to and refresh data from on-premises sources.
1.If the data source is SQL.Database, a gateway is required to perform the refresh.
2.you will need to install the gateway and provide necessary credentials for the database connection.
Please continue using Microsoft Community Forum.
If this post helped to resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan
Hi jaryszek,
Thank you for reaching out in Microsoft Community Forum.
Yes, your understanding is correct.If the data source is set to SharePoint only, and you're not using SQL.Database at all, then:
1.The customer does NOT need to install a gateway.
2.Since SharePoint is a cloud source, Power BI Service can connect and refresh data from it without a gateway.
3.The only requirement is that the customer has access to that SharePoint site and has provided appropriate credentials (OAuth) during dataset refresh setup.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
One more question,
if database SQL source is set up to be refreshed like that:
it will trigger the required gateway credentials ?
Best,
Jacek
Hi jaryszek,
Thank you for reaching out in Microsoft Community Forum.
Yes, if you have the SQL.Database source set up for refresh (as shown in your screenshot), it will trigger the required gateway credentials on the customer's end. This is because SQL.Database is an on-premises data source, and Power BI needs a gateway to securely connect to and refresh data from on-premises sources.
1.If the data source is SQL.Database, a gateway is required to perform the refresh.
2.you will need to install the gateway and provide necessary credentials for the database connection.
Please continue using Microsoft Community Forum.
If this post helped to resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan