Adressing the Graph API in SSIS

[Mike Platvoet]

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:

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).

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

[#2]

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.

[#3]

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

[#4]

Any update ?