Forum Discussion
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 up...
Hi,
I don't know why you have an error, but why not doing the filter after ?
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
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