How can we improve Power BI?

SSAS Get Data multiple data sources

When connecting to a live SSAS in Desktop, once you've connected "Get Data" and "Recent Sources" goes gray. Please allow for additional data sources to be added in after making a live connection to SSAS.

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

We’ll send you updates on this idea

Lauren Peterson shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

84 comments

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

    We would like to create relationship between different types of data sources - e.g. query data created by .pbix file and dataset from SSAS cubes. Any alternative solution would be appreciated.

  • Anonymous commented  ·   ·  Flag as inappropriate

    A big vote for me for this too please - I need to maintain excel coding to manage historic data that's not coded correctly in the live data source

  • Jeroen Habets commented  ·   ·  Flag as inappropriate

    Would this also fix my business need to be able to combine a live Power BI Service dataset with other sources?

  • Victor K commented  ·   ·  Flag as inappropriate

    To be able to connect to multiple SSAS MD Cubes is a must have feature for us to have PowerBI in our organization. As simply growing one cube for both Data Volume and maintenance is a difficult option at the moment.

  • Brad commented  ·   ·  Flag as inappropriate

    This is a pretty typical use case - it would be very helpful to have this feature.

  • D. Pearce commented  ·   ·  Flag as inappropriate

    Yet another reason I prefer to create reports in Excel and simply publish them.
    IMHO, there are *so many* features in Excel that are crucial for business data analysis in custom ways that are independent of the source(s).
    PowerBI MUST START trying to get equity with many of the Excel Data Manipulation functions.

  • Colin Eisele commented  ·   ·  Flag as inappropriate

    Yes please. We have custom budgets that aren't added into our SSAS because they're very niche. They're tracked manually in excel, currently. Would be great to track them in Power BI instead.

  • Pier1999 commented  ·   ·  Flag as inappropriate

    Definitely a ‘must have’ for an enterprise solution. My users work with a live connection to SSAS (cannot download the entire dataset on each worker's machine) but then want to integrate with data on the fly, perhaps coming from the latest market data, which would never made it to the datacentre on time to be useful to the final report.

  • Nicola commented  ·   ·  Flag as inappropriate

    Having more than one cube in a report is very important for several important report we need to deliver. Always relying on the cube itself getting fatter and fatter to become the uber-cube-that-solves-it-all is not feasible in many non-trivial cases.

  • Mike commented  ·   ·  Flag as inappropriate

    I currently work across a number of data sources and being able to tie them together is a must for me to create and represent the outcomes in a effective way. I would really need this function available for me to utilize PBI for my daily work flow.

← Previous 1 3 4 5

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.