Direct Query option for Odata sources

[fbcideas_migusr]

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

[basavarajmk1]

We need this urgently

[senka_ekic]

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?

[ross_lambert]

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.

[zhangjiajun0114]

we need this urgently.

[daniel_ohlmeyer]

Absolutely needed.

[pbiideas1]

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

[scott_melhop]

This would be a game changer for custom connectors!

[pbiideas1]

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..

[rakesh_gopalak1]

its really required stuff

[wesley_parks]

basic stuff that should be included