Adressing the Graph API in SSIS

Steel Contributor

Has anyone successfully adressed the Graph API in SQL Server Analysis Server? I am trying to read from the Graph API using SSIS and I have successfully connected to the API, using these settings:

 

2016-10-27_0906.png

 

However, I am not able to load any elements from the API. I tried the collection, which comes up with an error.

I have tried a Resource path (such as beta/groups) but that either hangs or comes up with an error 401 (unauthorized).

 

2016-10-27_0907.png

Does anyone know how to set up a connection with O365 in SSIS?

3 Replies

Have you solved this?  I tried to query the API in Power BI but the volume of data is too large to have a performant query so I was hoping to land the data in SSAS via SSIS, but I haven't been able to get this to work.

Any update on this? I've been trying to do the same thing--unsuccessfully.

Any update ?