Published report can't connect to database

[akeshvrz]

Hello guys,

- I have power bi reports published in power bi service. I connect using Live connection.

- I've setup on-premise data gateway and my data source is Analysis Services Tabular model.

- When I open the report in PBI service It shows this error: "There was a data source access error. Please contact the gateway administrator."

- I can connect to my datasource from data gateway server via Power BI desktop. 

- The ports 2382 and 2383 in data gateway are enabled.

- Gateway and cloud connection related to the report is assigned correctly and shows a green checkmark.

- On-premises data gate way has been configured correctly and status is online.

- Connection setting has been configured correctley and status is online.

- I've cheked UPN setting for my user account and it's OK.

- Privacy level is organizational.(I tested other levels but useless)

- My domain user account has admin permission to data source.

- I use windows authentication to connect to data source.

- My semantec model Live connection refreshes without error. But Import connection semantec model (a test connection) has the

following error:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AnalysisServices: The following system error occurred: The user name or password is incorrect. "}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"AnalysisServices"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"DatabaseServerName;DatabaseName"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Model (2).
Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID: 4c59db67-ed87-4424-a05f-3d464491dc63
Request ID: 3f711474-8193-fb5a-c73f-3cbd906039a3
Time: 2024-09-09 09:13:45Z

So I ask pleasem if anyone has the same experience please share with me.

Thank you so much.

[Anonymous]

Hi @akeshvrz 

Ensure that you have correctly performed the map user operation.
Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[akeshvrz]

Hi Jayleny,

I've checked with whoami /upn command and it's correct.

I even map the user account to it's email address in PBI service data source setting, but didn't work.

Regards,

Ali

[akeshvrz]

Hello Anktikt
Thanks for replying. 
I created a data model and could connect to my relational database (windows authentication). But I couldn't test Analysis Services model, because it was not an option to choose.

Thanks,

Ali

[AnkitKukreja]

Hi! @akeshvrz 

You are using Azure analysis services? Please try dataflow you should see the option there.

[akeshvrz]

No Azure.

On Premise SQL Server Analysis Service Tabular Model - > On Premise Data Gateway -> Power BI Service

Thank you

[AnkitKukreja]

Hi! @akeshvrz 

As your error shows details - The following system error occurred: The user name or password is incorrect. "}},

Please try to create a dataflow from service and see if you are able to connect to the source or not.