How can we improve Power BI?

← Power BI Ideas

Accessing multiple datasets in single report

I uploaded several datasets already available to me, and now i want to create a single report using them. Can there be a way to refer to multiple datasets in a single report?

131 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

18 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    This is a must heave feature for enterprise level reporting & dash boarding. It seems weird that this is not one available already.

  • Anonymous commented  ·   ·  Flag as inappropriate

    The datasets contain tremendous intellectual property value. To effectively constrain them to a single instance is very limiting. We create standard KPI's that should be able to be reused in connection with other related datasets. I hope this feature can become a priority.

  • WilkoVanA commented  ·   ·  Flag as inappropriate

    Can someone please merge a number of ideas with this one. There are multiple entries with this idea resulting in the votes getting diluted.

  • tchua commented  ·   ·  Flag as inappropriate

    This is one of the most important features that are missing. Yeah, you can add fancy stuff like 'ask a question' and all that can help the experience here or there, but this will be a make or break feature. It's very useful for when you don't know in advance what exactly you will be needing from your data.

    Will start looking into alternatives if there is no solution to this.

  • Josh LaSov commented  ·   ·  Flag as inappropriate

    This is a must! This will take auto-refresh to a whole new level and allow PowerBI to compete so much more effectively over Tableau and Qlik - which both can do this.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Seems crazy not to be able to do this. If you have a lot of historical data you can query it into a dataset, and not have to refresh it all the time... it can just be there. Then you would only have to query going forward...

  • Steve Thompson commented  ·   ·  Flag as inappropriate

    Really need this as the speedy proliferation of data sets starts to get very untidy, very quickly.
    Even the option to use a Power BI service source to drive an existing report by manually changing the fields. Laborious but at least reports can share data sources.
    It's not as if they are similar sources - they are the same

  • Marius commented  ·   ·  Flag as inappropriate

    This is a feature that we really need as well in order to utilize Power BI's potential.

  • Sridhar Manickavel commented  ·   ·  Flag as inappropriate

    From OMS we can configure to push data to Power BI, but it is creating separate dataset for each OMS rule/queries. If we need to create single report from multiple dataset then it is not possible.

    We need to have filters at report level from multiple dataset. Dashboard also not solving this usecase. OMS is not having enough option to view the data or enlarge the graphs.

Power BI Ideas: Data Sources

Categories

Feedback and Knowledge Base

(thinking…)

Ready to get started?

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