[teiid-issues] [JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

[Andrea Modesto Rossi (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13647110#comment-13647110 ] 

Andrea Modesto Rossi commented on TEIID-5503:
---------------------------------------------

PowerBI supports both ODBC and Odata connection method (as per [1] )meaning that there is a basic integration that already works out of the box. 

Regardless the Driver, PowerBI supports 2 connection methods [2]:

# Import
# DirectQuery

Both ODBC and Odata are 100% compliant with method 1), both neither ODBC nor Odata works in DirectQuery mode [3]. 

One Option, and this is the RFE goal, is to extend the capability of the existing ODBC driver according to Microsoft GuideLine:

* https://docs.microsoft.com/en-us/power-query/odbc
* https://github.com/Microsoft/DataConnectors
* https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md 

Hope this can help.


---
[1] https://docs.microsoft.com/en-us/power-bi/desktop-data-sources 
[2] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
[3] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources



> Create or change ODBC driver to be compatible with Microsoft Power BI
> ---------------------------------------------------------------------
>
>                 Key: TEIID-5503
>                 URL: https://issues.jboss.org/browse/TEIID-5503
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: ODBC
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>            Priority: Major
>
> Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc



--
This message was sent by Atlassian Jira
(v7.12.1#712002)