Unable to connect to Power BI api through SSIS

• kirti

  Old Hand

  Points: 387

  More actions

  September 30, 2021 at 12:43 pm

  #3935025

  Hi,

  I am trying to connect to power bi API from SSIS using OLEDB source. (Analysis service provide 14). Power BI API has Azure AD multi factor authentication. I am able to connect to it using SQL server management studio but not though SSIS.  It gives me a pop up to select the authentication account which is same as ssms. I also tried creating package across multiple versions as well. Not sure what can be the issue. Any pointers will be extremely helpful.

  I am getting following error:

  

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 1, 2021 at 1:10 pm

  #3935548

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.