catchqosa.blogg.se

How to get power query in excel online
How to get power query in excel online




To connect to your SAP Business Objects BI instance, you must set the following connection properties: You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). Follow the steps below to use Microsoft Query to import SAP BusinessObjects BI data into a spreadsheet and provide values to a parameterized query from cells in a spreadsheet.

how to get power query in excel online

The CData ODBC driver for SAP BusinessObjects BI uses the standard ODBC interface to link SAP BusinessObjects BI data with applications like Microsoft Access and Excel.






How to get power query in excel online