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?
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 ?