Power BI Desktop crashes when updating queries

[Anonymous]

I am using the latest Power BI Desktop (Version: 2.75.5649.582 64-bit (November 2019)) and have suddenly issues in renaming columns.

After changes have been made (Apply query changes), it takes a long time to creating connection in model, then the Desktop reports: "Something went wrong, an error ocurred while rendering the report".

After that, the Desktop has to be terminated via the Task Manager.

Background: I need to update column names regularly, as my source file is changed frequently. I did this method for more than a year now, but suddenly it crashes with the symptoms above.

[v-qiuyu-msft]

Hi @Anonymous, 

Which kind of column name will result in Power BI desktop crash? Please share more information so we can try to test the issue on our side. 

Best Regards,
Qiuyun Yu

[Anonymous]

Hello Quiyun,

thanks for taking care! It's not a specific column name. I am changing the names with pasting the respective statement in the Advanced Query Editor, because manually adapting the changes is cumbersome with a "broad" Excel Sheet and multiple Power BI Reports.

Please find below the statement - which I place at the beginning of all my report definitions. It was working well for more than one year:

"#""Renamed Columns"" = Table.RenameColumns(#""Changed Type"",{{""Column1"", ""BASF Service ID
Site Service ID""}, {""Column2"", ""BT Site Name""}, {""Column3"", ""Schdule 04 Status""}, {""Column4"", ""Region""}, {""Column5"", ""Region BASF""}, {""Column6"", ""Country""}, {""Column7"", ""City""}, {""Column8"", ""Site Address""}, {""Column9"", ""State - Province""}, {""Column10"", ""Postal Code""}, {""Column11"", ""Regional Coordinator""}, {""Column12"", ""Transformation Coordinators""}, {""Column13"", ""Site Type""}, {""Column14"", ""User Count""}, {""Column15"", ""Building Count""}, {""Column16"", ""Campus""}, {""Column17"", ""SLA (NICS)""}, {""Column18"", ""SLA Schedule 04, Use for LAN/UCC until final SLA determined""}, {""Column19"", ""SLA Final, After being called off""}, {""Column20"", ""SLA Pegasus LAN/UC Obsolete""}, {""Column21"", ""Service WAN Provider""}, {""Column22"", ""Service WAN Status""}, {""Column23"", ""Service LAN Provider""}, {""Column24"", ""Service WLAN Provider""}, {""Column25"", ""Service LAN Status""}, {""Column26"", ""Service UC Provider""}, {""Column27"", ""Service UC Status""}, {""Column28"", ""Access FE not allowed""}, {""Column29"", ""Access Meraki - no home office""}, {""Column30"", ""Access Registration""}, {""Column31"", ""Access Security Intro""}, {""Column32"", ""Access Security Training""}, {""Column33"", ""Access Pre Announcement OBS Engineer / HW""}, {""Column34"", ""Access Auto Pre Announcement""}, {""Column35"", ""Access Security & Access""}, {""Column36"", ""Access Car permit""}, {""Column37"", ""Access Site Access NBH""}, {""Column38"", ""Access Device Access NBH Access Building ""}, {""Column39"", ""Access Device Access NBH Access LAN Room ""}, {""Column40"", ""Access Device Access NBH Access Rack ""}, {""Column41"", ""Access Site Access ONBH""}, {""Column42"", ""Access Device Access ONBH Access Building ""}, {""Column43"", ""Access Device Access ONBH Access LAN Room ""}, {""Column44"", ""Access Device Access ONBH Access Rack ""}, {""Column45"", ""Access Escort""}, {""Column46"", ""Access Specify Escort""}, {""Column47"", ""Access Escort Details NBH""}, {""Column48"", ""Access Escort Details ONBH""}, {""Column49"", ""Access Safety Equipment""}, {""Column50"", ""Access Specific Documents Req""}, {""Column51"", ""Access Security & Safety Equipment""}, {""Column52"", ""Access Security Plan""}, {""Column53"", ""Access Delivery HW
to Site""}, {""Column54"", ""Access Material In
Material Out""}, {""Column55"", ""Access Photograph allowed?""}, {""Column56"", ""Access Photograph rules""}, {""Column57"", ""Access Other Site Requirements""}, {""Column58"", ""Access Specific Requirement""}, {""Column59"", ""Access Mini Questionnaire Link""}, {""Column60"", ""Contact Access First Name""}, {""Column61"", ""Contact Access Last Name""}, {""Column62"", ""Contact Access Phone""}, {""Column63"", ""Contact Access Mobile Phone""}, {""Column64"", ""Contact Access email address""}, {""Column65"", ""Contact Facility First Name""}, {""Column66"", ""Contact Facility Last Name""}, {""Column67"", ""Contact Facility Phone""}, {""Column68"", ""Contact Facility Mobile Phone""}, {""Column69"", ""Contact Facility email address""}, {""Column70"", ""Contact Primary Technical First Name""}, {""Column71"", ""Contact Primary Technical Last Name""}, {""Column72"", ""Contact Primary Technical Phone""}, {""Column73"", ""Contact Primary Technical Mobile Phone""}, {""Column74"", ""Contact Primary Technical Email Address""}, {""Column75"", ""Contact WAN Name""}, {""Column76"", ""Contact WAN Phone""}, {""Column77"", ""Contact WAN Mobile Phone""}, {""Column78"", ""Contact WAN Email Address""}, {""Column79"", ""Contact LAN First Name""}, {""Column80"", ""Contact LAN Last Name""}, {""Column81"", ""Contact LAN Phone""}, {""Column82"", ""Contact LAN Mobile Phone""}, {""Column83"", ""Contact LAN Email Address""}, {""Column84"", ""Contact UC First Name""}, {""Column85"", ""Contact UC Last Name""}, {""Column86"", ""Contact UC Phone""}, {""Column87"", ""Contact UC Mobile Phone""}, {""Column88"", ""Contact UC Email Address""}, {""Column89"", ""Contact Site Responsible Name""}, {""Column90"", ""Contact Site Responsible Phone""}, {""Column91"", ""Contact Site Responsible Mobile Phone""}, {""Column92"", ""Contact Site Responsible Email Address""}, {""Column93"", ""Site Survey Priority""}, {""Column94"", ""Site Survey Classification ""}, {""Column95"", ""Site Survey Reporting""}, {""Column96"", ""Site Survey Agreed Start Date""}, {""Column97"", ""Site Survey Agreed End Date""}, {""Column98"", ""Site Survey Effective Start""}, {""Column99"", ""Site Survey Trustsec Pilot""}, {""Column100"", ""Site Survey ATP""}, {""Column101"", ""Site Survey Completed""}, {""Column102"", ""Status Site Contacts verified""}, {""Column103"", ""Status Site Communication started""}, {""Column104"", ""tatus Site Security Requirements clarified""}, {""Column105"", ""Status Site Briefing done""}, {""Column106"", ""Status Site/Legal Entity Asset Transfer""}, {""Column107"", ""Status LTA date""}, {""Column108"", ""Status General Comments""}, {""Column109"", ""Status (discussing & verifying the technical and contractual elements, based on the planned status)""}, {""Column110"", ""Status Site Design accepted""}, {""Column111"", ""Status Approval of Migration Date WAN (by Site Manager)""}, {""Column112"", ""Status Approval of Service Level WAN (by Site Manager)""}, {""Column113"", ""Status Approval of Migration Date LAN (by Site Manager)""}, {""Column114"", ""Status Approval of Service Level LAN (by Site Manager)""}, {""Column115"", ""Status Approval of Migration Date UC (by Site Manager)""}, {""Column116"", ""Status Approval of Service Level UC (by Site Manager)""}, {""Column117"", ""Status Site migrated and in FMO LAN""}, {""Column118"", ""Status Site migrated and in FMO WAN""}, {""Column119"", ""Status Site migrated and in FMO UC""}, {""Column120"", ""Status Site migrated and in FMO Commercial""}, {""Column121"", ""Scope April 1 18 WAN""}, {""Column122"", ""Scope April 1 18 inet""}, {""Column123"", ""Scope April 1 18 LAN""}, {""Column124"", ""Scope April 1 18 UCC""}, {""Column125"", ""Scope April 1 18 video_conf""}, {""Column126"", ""Scope April 1 18 contact_center""}, {""Column127"", ""Scope March 1 19 WAN""}, {""Column128"", ""Scope March 1 19 inet""}, {""Column129"", ""Scope March 1 19 LAN""}, {""Column130"", ""Scope March 1 19 UCC""}, {""Column131"", ""Scope March 1 19 video_conf""}, {""Column132"", ""Scope March 1 19 contact_center""}, {""Column133"", ""Scope March 1 19 Comments""}, {""Column134"", ""Scope Actual WAN""}, {""Column135"", ""Scope Actual inet""}, {""Column136"", ""Transition Scope Actual LAN""}, {""Column137"", ""Transformation Scope Actual LAN""}, {""Column138"", ""Scope Actual UCC""}, {""Column139"", ""Transformation Scope Actual UCC""}, {""Column140"", ""Scope Actual video_conf""}, {""Column141"", ""Scope Actual contact_center""}, {""Column142"", ""Scope Actual Comments""}, {""Column143"", ""Transition LAN Proposed Date""}, {""Column144"", ""Transition LAN Actual Date""}, {""Column145"", ""Transition LAN status""}, {""Column146"", ""Transition LAN Pilot (Yes/No)""}, {""Column147"", ""Transition LAN Site classification""}, {""Column148"", ""Transition LAN Comments""}, {""Column149"", ""LAN Proposed Transformation Start Date""}, {""Column150"", ""LAN Confirmed Transformation Start Date""}, {""Column151"", ""LAN Transformation Completion Date""}, {""Column152"", ""LAN Transformation Status""}, {""Column153"", ""LAN Transformation Comments""}, {""Column154"", ""Transition UC Cisco Planned Date""}, {""Column155"", ""Transition UC Cisco Actual Date""}, {""Column156"", ""Transition UC Cisco Transition status""}, {""Column157"", ""Transition UC Cisco Pilot (Yes/No)""}, {""Column158"", ""Transition UC Cisco Site classification""}, {""Column159"", ""Transition UC Cisco Comments""}, {""Column160"", ""Transition UC Avaya Planned Date""}, {""Column161"", ""Transition UC Avaya Actual Date""}, {""Column162"", ""Transition UC Avaya Transition status""}, {""Column163"", ""Transition UC Avaya Pilot (Yes/No)""}, {""Column164"", ""Transition UC Avaya Site classification""}, {""Column165"", ""Transition UC Avaya Comments""}, {""Column166"", ""Transformation Cisco HW Refresh Transformation Status""}, {""Column167"", ""Transformation Cisco HW Refresh Planned start date""}, {""Column168"", ""Transformation Cisco HW Refresh Actual start date""}, {""Column169"", ""Transformation Cisco HW Refresh Hardware order date""}, {""Column170"", ""Transformation Cisco HW Refresh Hardware delivery date""}, {""Column171"", ""Cisco Planned transformation completion date""}, {""Column172"", ""Transformation Cisco HW Refresh completion date""}, {""Column173"", ""Transformation Cisco HW Refresh Comments""}, {""Column174"", ""Transformation Avaya Planned start date""}, {""Column175"", ""Transformation Avaya Actual start date""}, {""Column176"", ""Transformation Avaya Hardware order date""}, {""Column177"", ""Transformation Avaya Hardware delivery date""}, {""Column178"", ""Avaya Planned transformation completion date""}, {""Column179"", ""Transformation Avaya completion date""}, {""Column180"", ""Transformation Avaya Comments""}, {""Column181"", ""Transformation Contact Center Planned date""}, {""Column182"", ""Transformation Contact Center Actual date""}, {""Column183"", ""Transformation Contact Center Comments""}, {""Column184"", ""WAN Wave""}, {""Column185"", ""WAN Call-off Order BASF Sent Date""}, {""Column186"", ""WAN call off order accepted by RSS date""}, {""Column187"", ""WAN briefing sent date""}, {""Column188"", ""WAN planned hardware installation date""}, {""Column189"", ""WAN actual hardware installation date""}, {""Column190"", ""WAN desired Site Service Commencement Date ""}, {""Column191"", ""WAN Forecasted Site Service Commencement Date (calculated)""}, {""Column192"", ""WAN overall order status""}, {""Column193"", ""WAN Planned Site Service Commencement Date""}, {""Column194"", ""WAN Actual Site Service Commencement Date""}, {""Column195"", ""WAN SSCD status""}, {""Column196"", ""WAN SSCD deviation comments""}, {""Column197"", ""WAN Bandwidth Primary Access Type""}, {""Column198"", ""WAN Bandwidth Primary Access Speed""}, {""Column199"", ""WAN Bandwidth Primary Port Speed""}, {""Column200"", ""WAN Bandwidth Secondary Access Type""}, {""Column201"", ""WAN Bandwidth Secondary Access Speed""}, {""Column202"", ""WAN Bandwidth Secondary Port Speed""}, {""Column203"", ""WAN Bandwidth Initial Port Peak""}, {""Column204"", ""WAN Bandwidth Comment""}}),"

[Anonymous]

An update to the above statement - I remove the double "" and replace them before pasting into the Editor

[Anonymous]

Hi  @v-qiuyu-msft - I delivered some input on your question. Again many thanks for looking into my issue!

Regards,

Paul