I am trying to connect via Fabric Datafactory dataflow gen 2, to a database stored in SSAS, but I have the following error from my windows authentication:
My gateway is online and my credentials there are ok with my windows credentials for SSAS, I haven´t problems with PBI Desktop and I even have reports on desktop using data sources from SSAS published in service with refresh working well.
any idea what could be happening, and how can i resolve this error?
thanks!!
Hi @RicLup ,
According to the error message, you need to set the map user in the data source for AS.
Please refer this document: Manage SQL Server Analysis Services data sources - Power BI | 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.
Hi @RicLup ,
According to the error message, you need to set the map user in the data source for AS.
Please refer this document: Manage SQL Server Analysis Services data sources - Power BI | 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.
