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.

396 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    60 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • 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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is a HUGE requirement for Power BI Service. Need to refresh SharePoint list data using a function.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is a much needed feature! Note that a workaround is to use PowerBI Report Server on premise, the refresh works with functions.

      • Anonymous commented  ·   ·  Flag as inappropriate

        As much as functions are stressed in the Power BI and Power Query Deep Dive presentations, it is instrumental to allow us to use functions to fully utilize the capabilities of Power BI. I am currently refreshing and republishing the data manually several times a day, which over time, will drive us to search for another solution.

      • Aliaksei Liavitski commented  ·   ·  Flag as inappropriate

        It's very important feature. Anybody knows any workaround to refresh data from online app? In my case I load data from JIRA's API as source. I am using Json.Document(Web.Contents(<API URL>)) but parameters passing to URL from table. It means I generate table with column A with parameter values and then create custom column where data from source stored - Table.AddColumn(#"table", "data", each Json.Document(Web.Contents("<API URL>" & "?parameter=" & [parameterValue]))).

      • Anonymous commented  ·   ·  Flag as inappropriate

        Needs fixing quickly. Just spent 3 hours designing a report - all works fine on the desktop but as soon as I publish and try to set up the scheduler I find it's unsupported because of functions I've used in setting up the source data. :-( :-( :-(

      • Scott commented  ·   ·  Flag as inappropriate

        Absolutely a must. This stalls the functionality of most of the dashboards I create.

      • Anonymous commented  ·   ·  Flag as inappropriate

        100% frustrating to go through the process of preparing reporting using the List.Generate function to only find it won't refresh in the service. This feature is needed ASAP.

      ← Previous 1 3

      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.