Forum Discussion
Raymond Boone
Feb 21, 2018Iron Contributor
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...
Raymond Boone
Feb 28, 2019Iron Contributor
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.
- Jill KaszynskiFeb 17, 2020Copper Contributor
Raymond BooneHere we are almost another year later. Did you ever get this working?
- Raymond BooneFeb 24, 2020Iron ContributorThere'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.
- ChristineZ24Sep 02, 2021Copper ContributorI'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.
- Raymond BooneFeb 24, 2020Iron Contributor
Jill Kaszynski I just gave up and moved on.