Feedback by UserVoice

Wyn Hopkins

My feedback

  1. 100 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Should also happen when using Power Query to get data from a sheet so that you don't need to fix up Power Query later after you change the name of the Table

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Great idea

    Wyn Hopkins supported this idea  · 
  2. 28 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    For those without the connector you can copy this code and paste it into the Power Query Advanced Editor and then adjust the URL

    ONEDRIVE FOR BUSINESS

    let
    MainOneDriveFolder = "https://YourCompany- my.sharepoint.com/personal/Yourname_company_com",
    Source = SharePoint.Files(MainOneDriveFolder, [ApiVersion = 15])
    in
    Source

    SHAREPOINT

    let
    MainSharePointFolder = "https://YourCompany.sharepoint.com/YourOptionalSiteName",
    Source = SharePoint.Files(MainSharePointFolder, [ApiVersion = 15])
    in
    Source

    You could also swap out SharePoint.Files for SharePoint.Contents in order to navigate through shared documents and sub folders (and potentially faster refreshes)

    Wyn Hopkins shared this idea  · 
  3. 368 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks everyone for showing a lot of passion about Dataflows data connector in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.

    Guy Hunkin
    Principal Program Manager
    Excel Team

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    The new Power Query Rich Data Types functionality should be added here also rather than via the “featured table” option in Power BI

    Wyn Hopkins supported this idea  · 
  4. 84 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Agreed, just show the expanded box

    Wyn Hopkins supported this idea  · 
  5. 129 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    - expands and indents with Shift Enter
    - allow comments
    - can be detached and floated
    - formula can be named ( for lambdas)
    - allow auto expanding of formula bar to be turned off and on easily
    - colour coding when referencing variables
    -

    Wyn Hopkins shared this idea  · 
  6. 43 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    The Current Channel version now allows referencing to the cells in a Table column ( and the validation picks up the new items ) https://youtu.be/MD_iLh-UEmQ

  7. 115 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Gets my vote

    Wyn Hopkins supported this idea  · 
  8. 258 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    33 comments  ·  Excel for the web » Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for showing passion for Power Query and various improvements! We are indeed looking to implement this suggestion.

    In general, we’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like these ideas.

    Thanks!
    Jonathan Kahati
    [PM @ Excel]

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Here's a link to the current 2 workarounds. Neither is very satisfactory https://youtu.be/igcCbKqtwrk

    Wyn Hopkins shared this idea  · 
  9. 22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wyn Hopkins supported this idea  · 
  10. 63 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wyn Hopkins supported this idea  · 
  11. 30 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    This would be fantastic

    Wyn Hopkins supported this idea  · 
  12. 264 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    I definitely want it to expand automatically while typing or editing. I’m thinking that just selecting a cell with a multi row formula would cause an indicator (expand icon) to appear next to formula bar

    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    This becomes even more important now that the LET function is being introduced

  13. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Even better add a Power Query Connector : From File on OneDrive / SharePoint

    Wyn Hopkins shared this idea  · 
  14. 10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wyn Hopkins supported this idea  · 
  15. 52 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    The syntax // is used for DAX and Power Query to comment out code

    Would be great to have that in Excel too

  16. 19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wyn Hopkins supported this idea  · 
  17. 349 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi all,

    Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Thanks,
    Guy Hunkin
    Excel Program Manager

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    That's a shame Guy, thanks for letting us know though.

    Any chance you can add this link (to Ken's post) to your response as a workaround:

    https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

    Wyn Hopkins shared this idea  · 
  18. 305 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    This is a great idea for Dynamic Arrays. Optional parameters covering:

    split at left most / right most delimiter
    Number of splits

    Wyn Hopkins supported this idea  · 
  19. 135 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wyn Hopkins supported this idea  · 
  20. 17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Mynda Treacy's video demo's the issue nicely here
    https://youtu.be/2ViMm-wuM3U?t=561

← Previous 1 3 4 5

Feedback and Knowledge Base