While connecting PowerBi Dataset from SSIS through SSAS processing Task

Prabu, Chandran 41 Reputation points
2024-12-02T08:26:30.1966667+00:00

While connecting PowerBi Dataset from SSIS through SSAS processing Task , I could not make test connection successful. However, I could the tables of PBI dataset and while processing it is throwing the error like below

"[Analysis Services Processing Task] Error: Unable to obtain authentication token using the credentials provided. If your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please remove the user name and password from the connection string, and then retry. You should then be prompted to enter your credentials."

Im using "Native OLE DB\Microsoft OLE DB Provider for Analysis Services 14.0" Provider

Could you pls advise what needs to be done ?

Thanks in advance!!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,616 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,299 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.