How can we improve Power BI?

Explicit alert when "Any" data type is present

Two ideas here:
1.) Make the symbol for "any" data type a high visibility icon (i.e. a bright yellow warning symbol, radioactive symbol, biohazard symbol, etc)
"Any" data types cause many issues due to their erratic behavior when attempting to aggregate data.
2.) Display a pop-up warning whenever the "load and apply" is pressed if there are unresolved "any" data types. There's no need to ever have "any" data types in your data model. The issue should be resolved by the user immediately by specifying which datatype is more appropriate

16 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dan Ahlvin shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Russ commented  ·   ·  Flag as inappropriate

        Great call! This is needed as it will reduce errors later in the data modeling process.

      • Barbara Raney commented  ·   ·  Flag as inappropriate

        I would even add a suggestion to have a button to run Data Type detection on all ANY Columns in the model.

      • Barbara Raney commented  ·   ·  Flag as inappropriate

        This is a MUST!! Please vote it up!!
        The ANY Data type left in a data model has the potential to wreak havoc.
        Thanks!

      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.