How can we improve Power BI?

Make functions refreshable when the data source is a parameter of the function

Like discussed here: http://community.powerbi.com/t5/Integrations-with-Files-and/Refreshing-queries-with-functions-doens-t-work/td-p/2450 - queries where data access happens inside a function and where the data source is dependent on parameters to the function should be refreshable.

842 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Bernd Loigge shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

99 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Neil Stewart commented  ·   ·  Flag as inappropriate

    I had to take my code out of the function and into the body of Power Query code itself. Kind of messy. Would like to use functions.

  • M.Rux commented  ·   ·  Flag as inappropriate

    I Need this too, asap

    I dont understand how other users can work without this feature, when tables have Millions of entries and only one day/month/year is important...

    Why is it so difficult, to give a User-Prompt for Parameters, when need

  • Joey commented  ·   ·  Flag as inappropriate

    Any update here? Potential workarounds for parameterized ODBC DSNs?

  • Anonymous commented  ·   ·  Flag as inappropriate

    Pleaseeee add this Power BI team. I have a list of parameters that my team keeps updated in Google Sheets as that is their preferred method, but I can't refresh pulling from this external source. Need this data to make my API calls in Power BI.

  • Michael Colbert commented  ·   ·  Flag as inappropriate

    Just a thought, I wonder if DataFlows would get around this limitation? But is oData supported in DataFlows just yet?

  • Daniel commented  ·   ·  Flag as inappropriate

    Any updates on this? Having M work in desktop but not in the service is a real headache; getting this fixed would really help with keeping report development/publishing a more seamless process.

  • Matthew Montgomery commented  ·   ·  Flag as inappropriate

    This thread is three and a half years old...are there any plans to implement this? Not offering this functionality in the online refresh is essentially punishing users for trying to keep their queries and M code neat and organized with functions.

  • Raymond Boone commented  ·   ·  Flag as inappropriate

    Just published a report that used this functionality...only to find it isn't there. Hope you guys can make this work at some point.

  • Joaquin commented  ·   ·  Flag as inappropriate

    Please add this functionality, we would need it for our project =(

  • Redmond Hartop commented  ·   ·  Flag as inappropriate

    More needs to be done to iron out the discrepancies in the execution of desktop and service M code. This idea highlights this need. In the meantime this blog:
    https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/
    provides a useful workaround to automating some uses of functions and parameters. You may find though that switching the argument 'Query' for 'RelativePath' is more effective for your project.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I tried building a refreshable M Query using Datachant's iterative function here: https://datachant.com/2016/06/27/cursor-based-pagination-power-query/ and Chris Webb's method to trick the Web.Contents() static analysis of the URL here: https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/ BUT this combo doesn't seem to work. Any modification to the Web.Contents() text string that's passed into the function breaks the GeneratedList function. HELP!

  • iman yu commented  ·   ·  Flag as inappropriate

    would really need this functionality in order to make my report work

  • Thomas Krekling commented  ·   ·  Flag as inappropriate

    I have a parameter based report, refresh works on it. I have connected the report through my own developed web api. Using a azure app function proxy. The report refreshes nightly after uploading to powerbi cloud

  • Anonymous commented  ·   ·  Flag as inappropriate

    yes it gwould be very useful. I'm getting a lot the "You can't schedule refresh for this dataset because" error

← Previous 1 3 4 5

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.