Skip to main content
Microsoft Idea

    Power BI

    Completed

    oData feed

    Vote (296) Share
    Randy Walker's profile image

    Randy Walker on 22 Nov 2014 06:28:30

    Allow us to get data from our own or custom oData feeds

    Comments (11)
    Randy Walker's profile image Profile Picture

    vilas jadhav on 05 Jul 2020 22:16:44

    RE: oData feed

    Hi,
    Please help me for the Odata service for Power Bi report , my data records are 23 00000, odata can not give me this records and not able to upload using personel gateway
    Anyone please suggest for this.
    thanks
    vilas jadhav

    Randy Walker's profile image Profile Picture

    Carlos Moreno on 05 Jul 2020 22:16:37

    RE: oData feed

    It's not possible to change the Windows account credentials in the app.powerbi.com portal. However, I can do that in the Desktop versión... When will this available?
    Thanks!

    Randy Walker's profile image Profile Picture

    Arthur Nicholson on 05 Jul 2020 22:08:34

    RE: oData feed

    (Apologies for this being Dynamics CRM-specific) I do currently use oData as the way of connecting to CRM Online for several live customers. I don't use the Dynamics CRM connector exactly for this reason - we don't want to load everything and then filter down. What I'd really like to see is a FetchXML connector as opposed to oData given the significant performance and functional advantages. For CRM Online users, i have added a request for this which is sadly lacking in votes #Hint ;)

    https://support.powerbi.com/forums/265200-power-bi/suggestions/10308873-fetchxml-support-for-power-bi

    Randy Walker's profile image Profile Picture

    Julian Elve on 05 Jul 2020 22:04:30

    RE: oData feed

    I'd like to see this as a way of connecting to CRm Online without having to load the built in sales data pack (that I don't want)

    Randy Walker's profile image Profile Picture

    ERIC BLANCHE on 05 Jul 2020 22:03:08

    RE: oData feed

    I agree, this feature would be very useful for connecting to the Dynamics CRM online. We would need to filter the data directly through the request. If not, then we filter the result lines after the request ?

    Randy Walker's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:02:11

    RE: oData feed

    How may i refresh data using Windows credentials. Most of client using Windows Credential and not able to type domain user and password.

    Randy Walker's profile image Profile Picture

    Igor Yastrebov on 05 Jul 2020 21:59:18

    RE: oData feed

    oData is supported in terms of idea.
    You can create it in PowerBI Designer only at the moment.
    Next, DATA REFRESH does not work from PowerBI - this feature will be implemented soon.
    Next, you cannot manipulate with this DataSet from PowerBI API - API works with DataSets created from API :)

    So, a lot of work needed, MS :) good luck

    Randy Walker's profile image Profile Picture

    John Salichos on 05 Jul 2020 21:59:02

    RE: oData feed

    It is supported in Power BI Designer but I can't find a way to use with authentication (Basic)!

    Randy Walker's profile image Profile Picture

    Miguel Miguel.Llopis on 05 Jul 2020 21:59:01

    RE: oData feed

    "Basic" is the 3rd option in the Credentials dialog for OData feed. If you're hitting issues with this option, please use "Send a Frown" in the Designer which will send the issue to our engineers that can help troubleshoot the issue.

    Randy Walker's profile image Profile Picture

    Miguel Llopis on 05 Jul 2020 21:58:04

    RE: oData feed

    This is supported in Power Query and the Power BI Designer. You could already connect to these sources, build your reports and upload them / schedule refresh in the Power BI service for them.

    Thanks,
    M.