Forum Discussion

Djorran's avatar
Djorran
Regular Visitor
10 years ago

Schedule data refresh OData with parameter

Hi,

I wonder if someone knows a way to schedule a data refresh from Power BI with an OData query that have a parameter in it's url?

Both these urls works fine from the Power BI desktop but after uploading it to Power BI I can't schedule the query if I use the url where the date are a parameter.

 

Source = OData.Feed("https://odatamw111.navmoln.se:80/MW111Services/OData/Company('Company')/V_E_Query?$filter=Posting_Date eq DateTime'2015-101-01T00:00:00'")

 

Källa = OData.Feed("https://odatamw111.navmoln.se:80/MW111Services/OData/Company('Company')/V_E_Query?$filter=Posting_Date eq "&Startdate&"")

 

Kind regards,

Djorran

Need Help

7 Replies

  • Rémi's avatar
    Rémi
    Resolver III
    10 years ago

    Hi,

     

    I don't know why you have an error, but why not doing the filter after ?

    • Djorran's avatar
      Djorran
      Regular Visitor
      10 years ago

      Hi,

      Because when you work with OData the Power Query filter just filter the visual. So if you wan't to get transaction for a specific month you first need to read all transactions and then will Power Query apply the filter and only show you the transactions for the specific month.

       

      Kind regards,

      Djorran

      • birketa's avatar
        birketa
        New Member
        10 years ago

        Hi Djorran,

         

        Did you ever get a response for this.  I have a similar issue, however mine is compounded that the paremeter actually increases the data \data\Opportunities?cross-company=true.

         

        I have noticed that sometimes having the extra parameter will work, however mostly it does not.

         

        Kind Regards,

         

        Andy

  • Kristian's avatar
    Kristian
    Advocate I
    9 years ago

    Hi

     

    I'm also wondering if you ever get a response to your issue because I'm facing the same one. Would appreciate it!

     

    Thanks and kind regards

    Kristian

  • Kristian's avatar
    Kristian
    Advocate I
    9 years ago

    Hi

     

    I wonder if you ever get a responsre to your issue because I am facing the same one. I would appreciate any help!

     

    Thanks and kind regards

    Kristian

  • Rajkumar's avatar
    Rajkumar
    Advocate II
    9 years ago

    I'm also facing the same issue. parametrized query is working fine in the desktop s/w, but it is not getting refresh in the power BI site.

     

    My scenario is : I have to collect data from multiple project sites ( Project site is customized with couple of added lists) , so I'm passing project name as a parameter to the query , so that It will collect data for each project. This is refreshing awesome in Desktop, but not Power BI. 

     

    Power BI team, could you please look into this issue asap?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi,

    My issue is similar if not identical. I am connecting to OData v 4.0

     

    I need to fetch records since two Sundays ago from current date and also filter to get only a few columns. So, I used a parameter for the report start date, externalized the source URL, used Text.Combine() to construct the URL in the Advanced Editor.

     

    Something like this:

    URL = Text.Combine({CRMODataConnectString,"/leads?$select=column1,column2,column3, ... ,columnN&$filter=columnX gt ",ReportStartDate},""),

     

    But ever since I moved to

     

    Source = OData.Feed(URL)

    I am not able to refresh on the Power BI service. I get an error that schedule refresh is not supported for this Source. 

     

     

     

     

     

     

     

     

     

     

     

    I don't even get the usual sub menus under schedule refresh - like Gateway connection, Data Source Credentials and Schedule Refresh.

     

     

    On Power BI desktop, it is faster than ever due to the filters.