Skip to main content

    Power BI

    Needs Votes

    ODC equivalent for Power BI Desktop

    Vote (190) Share
    Jorge Segarra's profile image

    Jorge Segarra on 05 Mar 2017 04:20:15

    Office data connection (odc) files allow end users to quickly and easily launch , create a pivot table connected directly to a specified data source. I propose a Power BI data connection (PDC) file that had similar behavior. This would allow easy publishing access to data sources in enterprises so end users that wish to author custom reports against data sources don't need to jump through multiple steps to access data source. The PDC file would launch desktop tool and connect directly to configured data source in one step.

    Comments (14)
    Jorge Segarra's profile image Profile Picture

    b07f391d 412a-4537-92c7-8e591b3279d5 on 06 Jul 2020 00:04:18

    RE: ODC equivalent for Power BI Desktop

    I agree, this would be very helpful. We also need to be able to add the odc to the excel data model

    Jorge Segarra's profile image Profile Picture

    4785ce05 3a51-4448-a693-ecb70d81b75c on 05 Jul 2020 23:40:12

    RE: ODC equivalent for Power BI Desktop

    I guess that the File > Import > Excel workbook contents feature may partially close this gap, in particular, connect Power BI to a Power Pivot Data model.

    Jorge Segarra's profile image Profile Picture

    94f07601 6917-41f9-b076-8026c51c364d on 05 Jul 2020 23:35:27

    RE: ODC equivalent for Power BI Desktop

    Please Microsoft! Conection with .ODC

    Jorge Segarra's profile image Profile Picture

    197307e4 d40a-407d-8f60-e0e37810cfc8 on 05 Jul 2020 23:27:33

    RE: ODC equivalent for Power BI Desktop

    Yiou must !

    Jorge Segarra's profile image Profile Picture

    b9877b82 5735-4609-92e8-dbf061af8dc4 on 05 Jul 2020 23:27:03

    RE: ODC equivalent for Power BI Desktop

    PLEASE!!

    Jorge Segarra's profile image Profile Picture

    bccb9622 e2e8-e811-a96f-000d3a1bece3 on 05 Jul 2020 23:26:55

    RE: ODC equivalent for Power BI Desktop

    Yes

    Jorge Segarra's profile image Profile Picture

    b8a5f29b ecc5-41ce-b685-1dff1eaa4604 on 05 Jul 2020 23:02:23

    RE: ODC equivalent for Power BI Desktop

    For easier maintenance of multiple worksheet templates using server-based ODC queries, I would very welcome to have an exernal editor for these ODC files - or better: to have full SQL-support and XML-format compliance, so any editor "understanding" these formats could be used :)

    Jorge Segarra's profile image Profile Picture

    32af7704 5dee-44b9-9bcf-8116afa5ef39 on 05 Jul 2020 22:58:58

    RE: ODC equivalent for Power BI Desktop

    Yes please

    Jorge Segarra's profile image Profile Picture

    0c0b65ce 3da7-479a-8ea9-5e39ee08b7ce on 05 Jul 2020 22:54:05

    RE: ODC equivalent for Power BI Desktop

    Definitely a great time saver!

    Jorge Segarra's profile image Profile Picture

    7b93cc98 7573-4d8a-a53c-f68b741e996f on 05 Jul 2020 22:54:03

    RE: ODC equivalent for Power BI Desktop

    In order to facilitate reuse of queries and custom functions, we can now utilize ODC technology in Excel. PowerBI, on the other hand, uses a mechanism to incorporate extended connectors individually, so that we can start custom functions with the same interface as standard functions. I'm worried that Excel and PowerBI are beginning to take different measures, and I would like the development team to consider synchronizing both systems. In PowerBI, it is desirable to make use of ODC and also to refer to and use extended functions in Excel.