Forum Discussion
Dataset data source credential greyed out
I'm new to Power BI and have setup a connection to a SQL database on my network. Within the Power BI client I set my data source permissions to use my personal Windows credentials. Initially I had ...
Hi there
What you would need to do, is to install and configure the Gateway in Enterprise Mode
Once that is done, you would then click on Add Data Source, Select SQL Server put in all the details.
Once the above is done, you could then go to your dataset in the settings and then configure the data to be refreshed via the Gateway.
Here are more details how to get this done: https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial
What you would need to do, is to install and configure the Gateway in Enterprise Mode
Once that is done, you would then click on Add Data Source, Select SQL Server put in all the details.
Once the above is done, you could then go to your dataset in the settings and then configure the data to be refreshed via the Gateway.
Here are more details how to get this done: https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial