Home

Adressing the Graph API in SSIS

%3CLINGO-SUB%20id%3D%22lingo-sub-25163%22%20slang%3D%22en-US%22%3EAdressing%20the%20Graph%20API%20in%20SSIS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-25163%22%20slang%3D%22en-US%22%3E%3CP%3EHas%20anyone%20successfully%20adressed%20the%20Graph%20API%20in%20SQL%20Server%20Analysis%20Server%3F%20I%20am%20trying%20to%20read%20from%20the%20Graph%20API%20using%20SSIS%20and%20I%20have%20successfully%20connected%20to%20the%20API%2C%20using%20these%20settings%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20552px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F7646i9332F311C6E430C5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222016-10-27_0906.png%22%20title%3D%222016-10-27_0906.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20am%20not%20able%20to%20load%20any%20elements%20from%20the%20API.%20I%20tried%20the%20collection%2C%20which%20comes%20up%20with%20an%20error.%3C%2FP%3E%3CP%3EI%20have%20tried%20a%20Resource%20path%20(such%20as%20beta%2Fgroups)%20but%20that%20either%20hangs%20or%20comes%20up%20with%20an%20error%20401%20(unauthorized).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20760px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F7649i47E67B4E6BCD2619%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222016-10-27_0907.png%22%20title%3D%222016-10-27_0907.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%3E%3CIMG%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20set%20up%20a%20connection%20with%20O365%20in%20SSIS%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-223541%22%20slang%3D%22en-US%22%3ERe%3A%20Adressing%20the%20Graph%20API%20in%20SSIS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-223541%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20update%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168035%22%20slang%3D%22en-US%22%3ERe%3A%20Adressing%20the%20Graph%20API%20in%20SSIS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168035%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20update%20on%20this%3F%20I've%20been%20trying%20to%20do%20the%20same%20thing--unsuccessfully.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-50214%22%20slang%3D%22en-US%22%3ERe%3A%20Adressing%20the%20Graph%20API%20in%20SSIS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-50214%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20solved%20this%3F%20%26nbsp%3BI%20tried%20to%20query%20the%20API%20in%20Power%20BI%20but%20the%20volume%20of%20data%20is%20too%20large%20to%20have%20a%20performant%20query%20so%20I%20was%20hoping%20to%20land%20the%20data%20in%20SSAS%20via%20SSIS%2C%20but%20I%20haven't%20been%20able%20to%20get%20this%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent 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 ?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies