How can we improve Power BI?

power bi datasets

Power BI datasets

Now it is only possible to connect from Power bI Desktop to Power to 1 BI dataset. If you have on Power Bi Servics more datasets, like for different sources hr, finance, sales, operations it would be nice to have teh possibility to connect to more than 1 Power BI dataset in 1 Power BI Desktop Dashboard/Reports file and publish this to Power BI Services. You can see Power BI dataset as a datamart and it would be nice to integrate all in 1 dashboard. What is your opinion ?

73 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Marco Groeneveld shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

12 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • NWong commented  ·   ·  Flag as inappropriate

    Agreed - It would be great to connect to Power BI datasets in the service via Import Mode. Similar to how AAS allows you to connect via Import, but still respecting the RLS rules defined in the model.

  • Ralf Wegener commented  ·   ·  Flag as inappropriate

    Agreed! Creation of multiple data models to be combined into a single reporting tool is a valuable feature.

  • Oleg commented  ·   ·  Flag as inappropriate

    Absolitelly agree! It would add flexibility to the feature.

  • David commented  ·   ·  Flag as inappropriate

    Agree, if user who would like to use Power BI dataset from datastores where she/he doesn't have access, for example SQL server, then this could be valuable feature where user can combine own dataset and external one.

  • Anonymous commented  ·   ·  Flag as inappropriate

    We are attempting to merge and report on data from a SAAS application that is connected to the Power BI Service, with on-prem datasources. This is currently not possible because Power BI only allows you to work with one "app" datasource at a time. I was annoyed by this limitation as I can "get data" from other sources and merge/combine to my heart's content, but this is not possible with datasources from SAAS applications.

  • KD commented  ·   ·  Flag as inappropriate

    This is very valuable! In the end, the power of bi :) is to be able to create integrated datamodels not being forced to do that all within one source db. Next to that it would be handy to have the ability to to create additional inline tables for mapping etc...(this is a feature that Qlik and Tableau do have)

  • Kirsty commented  ·   ·  Flag as inappropriate

    Completely agree. We would like to be able to create multiple data models which may or may not be combined into a single reporting tool. For example our project office may only need the project master data and costs. Whereas Finance will want HR reporting in their model as well. Right now it's all or nothing.

    I thought the new dataflow option would solve this, but you can't edit/transform the data unless you have a premium license. So we're stuck with merging all data sources into one model, and having to refresh all at once even if some data refreshes at different rates. Disappointing.

  • Jacob Griffith commented  ·   ·  Flag as inappropriate

    Agree. Many of our reports rely on the set of millions of rows with only minor changes in Power Query or the addition of one extra table. We need the ability to edit and combine Power BI data sources.

  • Ted Wildsmith commented  ·   ·  Flag as inappropriate

    Completely agree - support for a Power BI report able to connect to multiple Power BI (service) datasets, or for mixed data sets (e.g. Power BI dataset and Azure SQL).

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.