Skip to main content

Power BI

Needs Votes

Direct Query option for Odata sources

Vote (150) 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 (18)
Ashish Ruparel's profile image Profile Picture

Power BI Ideas Admin 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

Scott Melhop 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

Power BI Ideas Admin 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

Power BI User on 05 Jul 2020 23:32:21

RE: Direct Query option for Odata sources

Absolutely needed.

Ashish Ruparel's profile image Profile Picture

Power BI User 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

Ross Lambert 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

sekic 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?

Ashish Ruparel's profile image Profile Picture

Basavaraju Kidiyappa on 05 Jul 2020 23:03:57

RE: Direct Query option for Odata sources

We need this urgently