Skip to main content

    Power BI

    New

    Direct Query option for Odata sources

    Vote (84) Share
    Ashish Ruparel's profile image

    Ashish Ruparel on 17 May 2016 17:57:32

    Can we have an option of Direct Query for Odata sources ?

    This will ensure that the data security implemented at the source will be recognized when the users are viewing the reports.

    In our case we are using MS CRM online for managing sales opportunities. We have created powerbi reports using the OData source. The challenge we have is when we publish these reports either as content pack or directly sharing the dashboard, all the recipient gets access to all the data that the publisher has.

    Regards,
    Ashish

    Comments (11)
    Ashish Ruparel's profile image Profile Picture

    22a05cbf 90d8-ea11-a813-000d3a4e3654 on 07 Aug 2020 09:36:33

    RE: Direct Query option for Odata sources

    I need that!

    Ashish Ruparel's profile image Profile Picture

    fc3e9604 8225-4f59-be97-d6c6093454e6 on 10 Jul 2020 17:20:41

    RE: Direct Query option for Odata sources

    basic stuff that should be included

    Ashish Ruparel's profile image Profile Picture

    a1eb343c d36d-406c-a98a-828bf081975f on 06 Jul 2020 00:16:21

    RE: Direct Query option for Odata sources

    its really required stuff

    Ashish Ruparel's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:56:15

    RE: Direct Query option for Odata sources

    THIS IS NEEDED SO BAD!
    How do they plan to integrate their top 2 hot softwares right now without creating a link between them!
    Cmon Microsoft, Dynamics 365 and Power BI need to rely on each other and Using Odata url/api is the best way to work with the Entities inside Dynamics 365 for now.
    Please get this solution for this!
    Truly this would be a game changer..

    Ashish Ruparel's profile image Profile Picture

    418bf5e0 b6cd-4779-8c16-6e0805cbd34e on 05 Jul 2020 23:56:04

    RE: Direct Query option for Odata sources

    This would be a game changer for custom connectors!

    Ashish Ruparel's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:36:00

    RE: Direct Query option for Odata sources

    And the reports will show the latest data rather than be based on old cached info

    Ashish Ruparel's profile image Profile Picture

    4bd97595 8c59-4aad-9fc7-0bdad4a6cd7f on 05 Jul 2020 23:32:21

    RE: Direct Query option for Odata sources

    Absolutely needed.

    Ashish Ruparel's profile image Profile Picture

    84eef861 5d4e-4cf6-8634-8605deaece49 on 05 Jul 2020 23:30:42

    RE: Direct Query option for Odata sources

    we need this urgently.

    Ashish Ruparel's profile image Profile Picture

    506beb46 dc8a-47dd-9b34-e8eddbae8fdc on 05 Jul 2020 23:24:18

    RE: Direct Query option for Odata sources

    Sekic... if you're still looking for a solution, we *might* have something that could help. I'd have to hear more to better understand what you're trying to accomplish.

    The product is called Conduit and it would allow you to centralize connection management, even for OData API connections. That may enable you to have different connections with different right.

    Ping me if you're interested.

    Ashish Ruparel's profile image Profile Picture

    1103ba19 b919-4978-b65f-55030397e51a on 05 Jul 2020 23:08:37

    RE: Direct Query option for Odata sources

    We request same for over a year. Development is slow and crappy because we must manually "overload" programming to adjust authorizations on both sides, CRM and PBI.
    Is it will be someday possible to get authorization compatible on both MS products?