Forum Discussion
Helper IPower BI Upload refresh greyed out
Hi all,
i have created a Power BI report in desktop which has a connection to our SQL.
When i publish the data i am unable to setup the refresh of the data because it is greyed out.
Does someone know how to get it working?
Thank you in advance.
Hi Teddibeer ,
Please try below ways:
1. Please try to install data gateway in the local machine that could access the SQL data source, then create gateway data source in Power BI Service Portal and set the dataset connection settings, then please try to refresh
2. If you already have a gateway installed locally that can access the database, contact the gateway's administrator to share this gateway with you to create a connection to the data source, or you can contact the gateway's administrator to share a connection to a database that already exists for you to use.
For more details, you can read related document: Manage a SQL Server data source - Power BI | Microsoft Learn, Manage an on-premises data gateway | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi Teddibeer ,
Please try below ways:
1. Please try to install data gateway in the local machine that could access the SQL data source, then create gateway data source in Power BI Service Portal and set the dataset connection settings, then please try to refresh
2. If you already have a gateway installed locally that can access the database, contact the gateway's administrator to share this gateway with you to create a connection to the data source, or you can contact the gateway's administrator to share a connection to a database that already exists for you to use.
For more details, you can read related document: Manage a SQL Server data source - Power BI | Microsoft Learn, Manage an on-premises data gateway | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TeddibeerWe did and apparently there isnt a gateway setup for my account.
If we take our admin account we do have a gateway so we have it working kind of but we still dont know how to get the gateway working for my account
- JoeBarry
Solution Sage
Hi Teddibeer
The Admin needs to go to https://app.powerbi.com/groups/me/gateways?experience=power-bi
Right click on the 3 dots beside the source and click on manage Users and you can be added there
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#manage-users
Thanks
Joe
If this post helps, then please Accept it as the solution
