Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I am facing difficulties with Refreshing a dataset in Power BI Service. Datasource is Azure sql database I have used import mode. I need to set up refresh.
Which Datagateway I should Install. VNET,Personal Datagateway or enterprise data gateway.
Thanks
Swarnika
Solved! Go to Solution.
Hey @swarnikasinha ,
using Azure SQL DB does not require using an on-premises gateway. A gateway is only required when you have to meet specific security requirements.
Can you provide the error message from the refresh history, make sue that you expand the detail hint?
Did you adjust the "Edit credentials" (see the below image) after you published the report to the workspace. This is required as "Publish" will not publish the credentials you are using on Desktop to avoid man-in-the-middle interference.
Hopefully, this provides some ideas on of how to tackle your challenge.
Regards,
Tom
Hi @swarnikasinha ,
Regarding your question, first of all, please be clear about your needs:
1.If you only serve yourself and do not need to collaborate with others and share your work, then you can choose a personal gateway;
For more information about how to use the personal gateway, see the following document: Use personal gateways in Power BI - Power BI | Microsoft Docs
2.If you need to put your work in a workspace and collaborate with others, we recommend that you use a standard gateway which you call enterprise gateway,
so that you can set up a gateway cluster and better manage the work that multiple people collaborate on.
For more information about how to install a standard gateway, see the following documentation: Install an on-premises data gateway | Microsoft Docs
After downloading the gateway, you also need to configure scheduled refresh, please refer to the following document on how to configure scheduled refresh: Configure scheduled refresh - Power BI | Microsoft Docs
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @swarnikasinha ,
using Azure SQL DB does not require using an on-premises gateway. A gateway is only required when you have to meet specific security requirements.
Can you provide the error message from the refresh history, make sue that you expand the detail hint?
Did you adjust the "Edit credentials" (see the below image) after you published the report to the workspace. This is required as "Publish" will not publish the credentials you are using on Desktop to avoid man-in-the-middle interference.
Hopefully, this provides some ideas on of how to tackle your challenge.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.