How can we improve Power BI?

Make "combine binaries" independent from existence of a particular file

Since the November 2016 upgrade of Power BI Desktop, the "combine binaries" functionality is strongly improved.
However, I have 1 suggestion for improvement already.
The "combine binaries" functionality creates some objects, including a query "Sample Binary".
This query returns the first file from the (selected) files in the folder.
Unfortunately, the name and path of this file are hardcoded, e.g. from the advanced editor:
#"C:\Users\Marcel\OneDrive - Bemint\Office 365\Power Query\DateTimeTables\_(UTC+0000) Casablanca xlsx" = Source{[#"Folder Path"="C:\Users\Marcel\OneDrive - Bemint\Office 365\Power Query\DateTimeTables\",Name="(UTC+0000) Casablanca.xlsx"]}[Content]

Consequently, when that file would be removed from the folder, you would get errors when refreshing this query.

So my suggestion would be to adjust that line of code - that gets created from the "combine binaries" functionality - to, for instance:
SampleBinary = Source{0}[Content]

Where "Source" is the name of the previous step.

This way the dependency on the existence of a particular file will be removed.
And there will be a mucher better step name as well.

30 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Marcel BeugelsdijkMarcel Beugelsdijk shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      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.