Not able to connect with the windows service account

[Sudharshan1919]

Hi All,

I have one requirement regarding Power BI Service. I have developed some reports and On Prem Database (My SQL Server) as a source( logged in with my Organisation Windows Service account) . It's working fine in PowerBI desktop.

Once I deployed  into powerBI service it's not connecting to the MySQL server .

I tried with install the gateway then Data Source Settings tab enabled. But while logging to connect to database from database settings of powerBI

It is having options like Authentication method and privacy levels dropdowns. Please suggest  which Authentication method ( Basic, WindowsWithoutImpersnation, OAuth2) and privacy levels ( None, Private, Public, Organisational ) I need to select. 

I am using my organisation email id to login into powerBI (Authentication method and privacy levels) And for the Sql database I am using windows service account.

Thanks

[Anonymous]

Hi @Sudharshan1919,

According to your snapshots, it seems like the 'personal' mode gateway is not suitable for your scenario.
You may need to change to use the 'on-premise' mode gateway to setting schedule refresh of the on-premise data source. (notice: you need to confirm the device which you installed the gateway can be accessed to the on-premise data source that you used design report)

Reference links about config scheduler refresh and the data source types that gateway supported:

Configure scheduled refresh - Power BI | Microsoft Docs

Power BI data sources - Power BI | Microsoft Docs

On-premises data gateway - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[negi007 · Accepted solution]

@Sudharshan1919 i guess you need a powerbi on premises gateway to connect to your sql server from powerbi services. Once you have powerbi gateway installed, then you can gateway credentials to connect to sql server.

pl. go through this link for detailed instructions.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial#connect-a-datase...

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

there is another way of connecting to your sql server using ODBC dsn. You create a odbc dsn and provide database credetails while configurating the DSN. You can then connect to your SQL server from powerbi desktop using this DSN and same will be available online. However, using this method your refresh will be through on personal gateway which will create dependecy on your personal laptop or computer. i hope this helps you.