Refresh Errors from Changing Column Names? Here's an easy fix // Beginners Guide to Power BI in 2021

[@sirisoj]

Beautiful approach! Thank you sr.

[@SolutionsAbroad]

Thanks for watching!

[@rustytoyn113]

Thanks Fernan. Nicely explained as always

[@ashishmohan4707]

Hi very useful video and very practical need everyone for every project ......very big thanks to share with us. That's the thing which i am looking because i was facing these kind of of issue country level data but now i nvr faced these kind of issue Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[@SolutionsAbroad]

Appreciate it, thanks!

[@chetnabhola4056]

Thank you !! It is very helpful

[@SolutionsAbroad]

You're welcome!

[@didieratehortuamorales4211]

Excellent! Thanks for sharing!

[@SolutionsAbroad]

My pleasure!

[@marianamarini]

Would I have to do this formula for all columns of my report if many are subject to changing?

[@tlee7028]

Just started following your vlog. What if I have 10 Headers names to change?

[@SolutionsAbroad]

Hi there! unfortunately this method was a bit hacky, so if you have a lot of headers to change you'll need to change them all individually

[@riazuddin7493]

Thanks Fernan please also tell us the same for M codes. This will really save time in preparing similar reports on monthly basis where lot of DAX is used

[@SolutionsAbroad]

Hi Riaz, this is essentially an M code but edited in the UI, I'll see if I can dig up the files used in this video for your reference

[@fatimasami8025]

Is this will apply also for SQL server if I added a new columns ?

[@pralhadgujar9113]

Thanks Fernan, What if i have more than 10 headers?

[@jimmymorin9562]

What if my Query has over 100 applied steps and 90 columns, meaning that every single applied steps always references the column names every time. (Adding a column or reordering a column references all the table's columns every time). If a column name changes in the source data, I would have to go back and change it a 100 times. Or if I do what you explained in the video, I would have to do this 100x90 in the codes, which would be crazy.

[@keiljuanaphillips9663]

Thanks so much!

[@vasanthavasu1030]

it's helpful please stop the noise from the background.

[@SolutionsAbroad]

Thanks for the feedback, I've removed that on my most recent videos now

[@NovaSat-g9t]

Hi, how we can update our Power Bi dashboard when we add more column to our dataset in Excel, and when we insert a column in between, the column next to it removed and gives error that the column not found., and when i insert it at the end the column values changed to null in power bi. Kindly update. thanks

[@tlee7028]

Are you able to share this error - the keys did not match any rows in the table? Thank you

[@aneeshpalla9530]

Hi. When i am adding the table to power bi from google bigquery getting this error. the table has no visible columns and cannot be queried. What might be the reason. Could you please suggest

[@SolutionsAbroad]

If there are no visible columns, perhaps there is some sort of restriction on your permissions to see those columns. Have you tried pulling the data using a different method?

[@aneeshpalla9530]

@@SolutionsAbroad yes one method it worked but we need to write the query for each table in that method

[@blakshmi3413]

I am Facing in power bi, when I am fresh in power bi it won't refresh. When I am changing edit parameters that time I am clicking apply changes I got some issue, "A cyclic reference was encountered during evaluation" and "Loading blocked by failures with other queries" pls let me know how to resolving this issue

[@Luis.C.Canchan]

Muchas gracias Fernan.

[@Stan-di3cm]

Life Saver!!!

[@abhijitchatterjee7326]

great results 👍

[@SolutionsAbroad]

Thanks Abhijit!

[@richardpearcephotography599]

The problem I often experience is when new columns are added to the data source table. The new columns are not automatically added when you refresh the data.

[@SolutionsAbroad]

Hi Richard, apologies for the late response on this! If you're using data sources like excel files you typically wont get new columns automatically added because you're essentially selecting a range of cells. There are ways to automate it, the best way I can see is from this article techcommunity.microsoft.com/t5/excel/refresh-query-to-add-new-columns/m-p/1192306 Perhaps i'll cover it in a video!

[@royeden1084]

A new column was added in the SharePoint list and now desktop refresh is failing...any idea why?

[@SolutionsAbroad]

I would say because one of your steps in PBI desktop isn't expecting the new column, best retrace it from Power Query in Power BI

[@walidhome4484]

thanks

[@kamleshsahane9439]

Suppose i need that column name as it is instead of days is it possible to do please help?

[@varoothini]

Hi, I'm having an issue deleting a column that's already imported to the report. Is there a way for it to work with refresh ?

[@SolutionsAbroad]

Hi, have you tried deleting it from the source? Or you could also try deleting the column higher up in the Applied Steps?

[@varoothini]

@@SolutionsAbroad Hi, yes I deleted in the source and refreshed the query. It says column 'xyz' of the table wasn't found.

[@SolutionsAbroad]

@@varoothini It sounds like you have a step that's still referencing the deleted column, check the advanced editor after the step where you deleted the column. This step most likely will be trying to transform the column, but because you already deleted it, its throwing the error

[@varoothini]

@@SolutionsAbroad Thanks for the reply. Is there a way to make it work without opening advanced editor ? Mainly after the report is published to PBI Service.

[@SolutionsAbroad]

@@varoothini You'll need to download the PBIX file and open the queries, unfortunately there's not much editing you can do from the service, at least for datasets

[@AliAlSayer]

what if the data soruce changed sort of column

[@SolutionsAbroad]

Hi Ali, this solution assumes that the column sorting from your source stays the same, if it changes you'll need to make the report changes accordingly

[@vartikathakur4273]

How to proceed without Promoted Headers?

[@SolutionsAbroad]

Hi Vartika, if you prefer to type your own column header names, you can remove the promoted headers step, rename your column headers, then remove top 1 rows, this will fix the issue for you too

[@idaraokposen7444]

This did not work for me, instead some of the visuals I created disappeared

[@sanjayTECH04]

Sound Quality Echo