Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Column Level & Row Level Security for Dataflows

    Ability to define rules at Row & column level, to control the data fields available to different roles (e.g. employee salary visible to the users in finance roles only, while other employee details visible to other department roles).

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

    We’ll send you updates on this idea

    15 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  2. Connect to Dataflows from Excel's Power Query

    Please allow the connection to Dataflows' entities from Excel's Power Query.
    There are many cases when customers use Excel and not Power BI. But Dataflows can make the refresh process much faster for them.
    Thanks

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

    We’ll send you updates on this idea

    24 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  3. Dataflows Direct Query

    Dataflows would be really useful if you could connect to them via DirectQuery. This would mean that we could query enormous dataflows that are not practical to load to the Data model and can make aggregate dataflows that we load to the Data model.

    Unsure if this is possible with the architecture of a Dataflow, but it could be quite handy if it is possible.

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

    We’ll send you updates on this idea

    under review  ·  24 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  4. refresh dataflow with Flow

    The new capability to refresh a dataset in Flow is great - would like to see that functionality extended to dataflows as well.

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

    We’ll send you updates on this idea

    1 comment  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  5. Better deployment method for Dataflows

    Our policy is perform dev and test efforts separately from production, therefore we develop and test data sets and Data flows in test work spaces. Once we are satisfied with their behavior and performance, we publish them into the production workspace. With PBIT files, it is easy for us to publish approved data models and reports into the production work spaces. Because data flows are built within PBI Service and have no file association, it is difficult to migrate them from test to production. We currently have to rebuild the entire Data flow in production, which is risky an cumbersome.

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

    We’ll send you updates on this idea

    1 comment  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  6. View Dataflow data sizes

    Enable an option to find the size/storage of a dataflow entity in Power BI service and Premium Capacity Metrics App.

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

    We’ll send you updates on this idea

    2 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  7. Share Dataflow Ownership with Workspace Admins

    We need to allow all admins of the workspace in which the dataflow is held to be able to edit the flow. Multiple people contribute to a dataflow at different stages of a project but all need to be able to review, understand and if necessary edit the dataflow

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

    We’ll send you updates on this idea

    0 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  8. DataFlow Copy/Paste Queries from PBI Desktop/Excel

    Ability to copy paste queries from PBI Desktop/Excel to DataFlow in PowerBI Service to create new DataFlows.

    The UI in PBI is more friendly, we often design the queries in Excel and PowerBi Desktop, to copy them into service, especially for the nested queries, it's a long and arduous process of copying each one into the service from advanced Editor and matching names.

    We are making a lot of data behind datasets available to the users. It'll be very convenient for major users of DataFlows

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

    We’ll send you updates on this idea

    0 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  9. Dataflows linked entities Pro Licence

    The new Dataflows concept looks really interesting and holds massive potential to change the BI landscape.
    Currently linking dataflows is only applicable to Premium licences. Based on how Dataflows are pitched as an Excel type approach to ETL I find it unusual that linked entities are only appropriate for Premium licences, especially since the analogy of an entities is a 'cell' in Excel. This is like shipping Excel with only one cell in it as a product for non-premium users. Premium capacities are only appropriate for huge organisations with hundreds of licences to make it financially viable. I would consider…

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

    We’ll send you updates on this idea

    under review  ·  11 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  10. Ability to hide tables in final output of a Dataflow

    Just like in de power query editor in the desktop version of PBI, the ability to hide some tables in the final output of a dataflow. For a client we prepare and combine all the data from different sources and add them together in the premium dataflow. But only the end result queries should be selectable.

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

    We’ll send you updates on this idea

    0 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  11. Measuring Power BI dataflow

    Power BI dataflows provide a great medium to syndicate sets of data to business units to run analytics. It enables faster access to reporting data.

    While there are highlevel utilization metrics on PBI reports, there is no way to measure dataflow utilization and uptake. It is critical to PowerBI success to understand the number of reports currently connected to any given dataflow and quantity of refreshes. Without a method to measure adoption and utilization of each dataflow, growth and ROI become guessing games.

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

    We’ll send you updates on this idea

    0 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  12. R Transform Power Query Dataflow

    It would be great to add R (And Python for that matter) scripting to a Dataflow process in Power Query Online.

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

    We’ll send you updates on this idea

    1 comment  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  13. One single schedule task for sequential refresh of both Dataflows + Dataset

    The biggest thing that I’m missing is the ability to schedule a Dataflow, plus a Dataset (without Premium capacity). Now you can schedule both separately, but not in an automated sequential way.

    https://ssbipolar.com/2018/11/24/whats-missing-from-power-bi-dataflows/

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

    We’ll send you updates on this idea

    under review  ·  11 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  14. Use SAP BW as datasource directly in the dataflow

    We need to connect to SAP BW as a data source directly in data flows and not via the blank query or M Query route which is suggested on Microsoft site. This connection should be exactly the way we connect in Power BI desktop via Application or Message server.

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

    We’ll send you updates on this idea

    1 comment  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  15. Dataflow-based Datasets in service

    The dataflows product is potentially very useful - I especially like the idea of being able to append historical data to incrementally refreshed data.

    However, one major drawback is the fact that in order to use a dataflow in a dataset, you have to download it to the desktop, and then upload it back to the service once you've completed your data model.

    It would be great if you only had to use the preview version of the dataflow in desktop, or even better, if you could do all modelling, DAX etc. completely within the service.

    If there are workarounds…

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

    We’ll send you updates on this idea

    1 comment  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  16. Dataflow Permissions

    Just like outstanding requests to assign app/workspace permission at a folder level within the app, we need to be able to give some users access to just individual dataflows without giving them access to the entire workspace that the dataflows are contained in.

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

    We’ll send you updates on this idea

    4 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  17. SQL Server Analysis Service connection to Dataflow

    Support Dataflow connections to SQL Server Analysis Service (SSAS), which desktop data sets allow users to do.

    At the moment, dataflow does not even support the use of a copied M script from desktop connected to SSAS in a blank query.

    See forum post below:
    https://community.powerbi.com/t5/Service/SQL-Server-Analysis-Services-as-a-Dataflow/m-p/828241#M79336

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

    We’ll send you updates on this idea

    1 comment  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  18. Parquet format support as Dataflow file storage

    Give the option to store Dataflow data in Parquet format, this can improve storage efficiency and Dataflow processing compared to .csv files.

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

    We’ll send you updates on this idea

    2 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  19. Ability to undo a deleted dataflow

    Once a dataflow is deleted then it's gone. It's a BCP issue and we need to have some sort of undo or a recycle bin where it can be restored for some time.

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

    We’ll send you updates on this idea

    0 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  20. Allow Parameters to be saved in Dataflows

    At the moment, parameters cannot be created and saved in dataflows. Parameters are automatically converted to a table when saving the dataflow.

    Parameters are useful to easily change or update specific values in SQL queries.

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

    We’ll send you updates on this idea

    started  ·  8 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 9 10
  • Don't see your idea?

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.