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.

541 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    74 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Danaraj commented  ·   ·  Flag as inappropriate

        This is a must have function in order to use parameterization in data source.

      • Justin Fenico commented  ·   ·  Flag as inappropriate

        Just realized this is an issue and really hampers the ability to use any type of Power Bi Template with parameters in it.

      • Garry commented  ·   ·  Flag as inappropriate

        Hows this going? any progress especially an issue with all the API data out there

      • Lam commented  ·   ·  Flag as inappropriate

        I expected this to be a basic requirement, but surprised that it's not there, Please add this

        Thank you very much !

      • Anonymous commented  ·   ·  Flag as inappropriate

        Serious functionality problem here. At least provide us feedback at the construction phase of reporting. Painful when you realise a new solution needs to be generated to resolve this 'bug'

      • Vikas Garg commented  ·   ·  Flag as inappropriate

        I am facing the same issue. I have 10-15 reports which were working fine before couple of weeks and all were using function but it stopped refreshing suddenly and now I am in deep trouble.
        How this can be resolved quickly ?

      • Anonymous commented  ·   ·  Flag as inappropriate

        How many votes are needed to implement this functionality. I have created several workarounds to overcome this hurdle, but since last month, the scheduled refresh on queries with custom functions and parameters has stopped working.

      • Eric V. commented  ·   ·  Flag as inappropriate

        Just spent 3 hours solving a function / M challenge - to find out that PBI.Com can't run functions. Nice. (Grrrr)

      • Viktor commented  ·   ·  Flag as inappropriate

        I don't understand why this is a problem. So, hope to get it solved soon

      • Wade commented  ·   ·  Flag as inappropriate

        Badly needed. I just got through updated reports for DNS, parameterized, and then republished report only to realize that I can't refresh anymore. wth?

      • Anonymous commented  ·   ·  Flag as inappropriate

        Its so frustrating when I can build a report in desktop, have it all working perfectly and then as soon as I publish it things no longer work... please stop doing this!

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hmm how else are we supposed to deal with paginated APIs?? Between this and the much-demanded and delayed incremental updates requirement, MS does seem to have an issue with large datasets.

        Which isn't the most brilliant thing for a business intelligence tool.

      • Sanaa commented  ·   ·  Flag as inappropriate

        This feature will make life much easier and the use of the tool much more convenient.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is a must requirement for me as well, as I am refreshing the data from Jira web with pagination manually.

      ← Previous 1 3 4

      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.