Forum Discussion
Connecting to the Office 365 Reporting ODATA feed in SSIS
I've been trying to connect to the ODATA feed located here https://reports.office.com/pbi/v1.0/<tenantid> with SSIS. I can connect Excel 2016 and Power BI to it and consume data. SSIS looks like it w...
Welp it's still an issue a year later. I can still connect in Power Query (in Power BI or Excel) but not via SSDT--whether it's an SSIS package or a tabular data model. Even the new Power Query source for SSIS can't do much past make a connection. It errors out when you actually try to use the connection for anything.
Raymond BooneHere we are almost another year later. Did you ever get this working?
- There's probably some other way to query 365 to get the info--maybe it's Office Graph. I just wish someone (from Microsoft) had chimed in to tell me that.
- I'm looking for help in this area too. I can't connect to the Office 365 data set in local Power BI desktop, my account is connected and I can access online. When I do the get data for the OData feed, I get a "datasource.error: Odata: A support MIME type could not be found that matches the content type of the response. ....." Wondering if there are additional permissions that need to be granted to allow the connecting Odata from local. Any one from Microsoft can respond. Seems like others on this thread have given up.
Jill Kaszynski I just gave up and moved on.
