![]() We will achieve that by creating an ODBC data source using ZappySys ODBC PowerPack and then querying corresponding Microsoft Graph API methods. Specifically, we will get Excel file data in OneDrive, events from a Calendar and finally, a list in a note in OneNote and then load that data into a Power BI report. In this article, we will get Office 365 data in Power BI using Microsoft Graph API and ODBC drivers. ![]() 6 Manage gateways and configure the schedule.5 Working with Gateways in Power BI (Schedule Import).4.4.1 Reading files from OneDrive (getting Excel data).4.3 Set up an ODBC data source based on ZappySys XML Driver.4.2 Set up an ODBC data source based on ZappySys JSON Driver.4.1 Open ODBC Data Source Administrator.4 Register Application (OAuth2 App for Graph API).3 Step By Step – Get Office 365 data in Power BI using Microsoft Graph API and ODBC.
0 Comments
Leave a Reply. |