Editing a Column in data source

Resolved · Low Priority · Version 2016

Thu 28 Nov 2019, 12:41 Delegate Lou said...

Lou has attended:
Power BI Modelling, Visualisation and Publishing course
Excel VBA Introduction course

Editing a Column in data source

Hi,

I need to change the column exported from our database, but when I do this, POwer BI views it as an error, even if I change the heading in BI.

Any help would be appreciated!

Thanks,

Mon 2 Dec 2019, 09:32 Trainer Jens said...

RE: Editing a Column in data source

Hi Lou,

Thank you for the forum question.

I need more information to be able to help you. Very often when I meet errors during import, it is the data type in the column, which give me problem.

Please let me know the exact error message you get from Power Bi. You can get a lot of knowledge about the error by looking at the query editor.

On the View tab in the query editor in the Data Preview group you can get a lot of useful information to understand the errors you have.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 2 Dec 2019, 11:28 Delegate Lou said...

RE: Editing a Column in data source

Hi Jens,

I've changed the field I export from the database, but it's the same type of data. The error I get when I try to load this now is
"The column 'Appeal ID' of the table wasn't found."

The field I originally exported was Appeal ID. I'm now trying to export Appeal List.

I'm not sure I can even get to query editor if it won't load the data?

Thanks,

Mon 2 Dec 2019, 11:45 Trainer Jens said...

RE: Editing a Column in data source

Hi Lou,

Make a copy of the file. In the Query Editor select the table with the column you want to change. On the View tab open the Advanced Query editor. Replace Appeal ID with Appeal List. Appeal ID may be there multiple times. Click OK.

It is very important that you first try this on a copy of the file. It is very easy to do something wrong in the Advanced query editor.

If it is working copy the Power Query M code from the advanced query editor and paste it in the advanced query editor for the table in the real file.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 9 Dec 2019: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Implement Row-Level Security (RLS)

If your reports contain sensitive information, implement Row-Level Security to control access to data at the row level. RLS allows you to define rules that restrict data access based on user roles, ensuring that each user sees only the relevant data according to their permissions.

View all Power BI hints and tips