Power BI

Needs Votes

Direct Query option for Odata sources

Vote (150)

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)

Comments (18)

KEIICHI HIRANO on 28 Aug 2024 03:28:15

RE: Direct Query option for Odata sources

This is urgently needed.Many SAP users want this, and some are switching to other BI tools due to the lack of functionality.

Balachandar Gopal on 07 Oct 2022 17:29:07

RE: Direct Query option for Odata sources

this is essential. Please

Sathees Kumar P on 15 Jul 2022 03:39:50

RE: Direct Query option for Odata sources

Power BI - Transform Data -> Apply & Close of SAP OData service doesn't support Client Side paging with $top and $skip.When I tried with SAP OData service with Server side paging with $skiptoken, it works fine. :-)

Sathees Kumar P on 13 Jul 2022 10:54:52

RE: Direct Query option for Odata sources

I am using OData source from SAP. Service was restricted with 100 records if no paging is requested to avoid performance issue. Transform Data -> when accessing data paging supplied I can see up to 1000 records. But in actual data model it show 100 records because no paging was used, service returns only 100 records if no paging information.