Forum Discussion
Published report can't connect to database
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.
6 Replies
- AnkitKukrejaSuper User
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.
- akeshvrzRegular Visitor
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
- AnkitKukrejaSuper User
Hi! akeshvrz
You are using Azure analysis services? Please try dataflow you should see the option there.
- akeshvrzRegular Visitor
No Azure.
On Premise SQL Server Analysis Service Tabular Model - > On Premise Data Gateway -> Power BI Service
Thank you
- AnonymousNot applicable
Hi akeshvrz
Ensure that you have correctly performed the map user operation.
Manage SQL Server Analysis Services data sources - Power BI | Microsoft LearnBest Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- akeshvrzRegular Visitor
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