How can we improve Power BI?

Allow mixing direct query and imported tables in a single model

Allow direct query tables and imported tables to coexist in a single model with ability to create relationships between them.

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

We’ll send you updates on this idea

Srinivasan Turuvekere shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

31 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Tony Lau commented  ·   ·  Flag as inappropriate

    This is an absolutely must have feature and provide a truly agile and flexibility to the users to work in a mix mode ie. direct query and import data to work with. This is a draw back from my point of view.

  • Jayden Sanders commented  ·   ·  Flag as inappropriate

    This is very important for us at an enterprise level. Our use of PowerBI would increase if we could use direct query and import into a single model.

  • Henri Aalto commented  ·   ·  Flag as inappropriate

    It is almost funny in how many cases my end users wish to see the finest grain details for a specific customers when they start looking deeper into some phenomenon. Any way I can easily enable them to dig deeper in to the details without exploding the model is welcome. The ability to switch to another page in the report retaining filtering values is great, now to get further the detail-page would need to fetch the most detailed data over a direct query.

  • Marek commented  ·   ·  Flag as inappropriate

    Definitelly, something we need. Also, mixing multiple sources in the direct query (for example, 2 different sql servers)

  • Stuart Mackereth commented  ·   ·  Flag as inappropriate

    We have 1500 power bi licensed users... it's really a problem explaining that the self service reporting tool doesn't allow mashups of custom data with formal data!

    Biggest feature request from our organisation!

  • Ananda Kumar commented  ·   ·  Flag as inappropriate

    This is a common scenario in many of my projects. If it is self service BI then customer need to import their own Excel sheets to a direct query connection model. This is a very severe limitation.

  • Andrew commented  ·   ·  Flag as inappropriate

    This is the entire reason my company needs Power BI! I started using BI and now that I have access to our SQL Server, I came to find out I cannot combine the data I need to combine unless it becomes possible to use DirectQuery from 2 different databases on the Server plus mix in some imports.......

← Previous 1

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.