98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Editing a Column in data source
Editing a Column in data source
Resolved · Low Priority · Version 2016
Thu 28 Nov 2019, 12:41Delegate 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:32Trainer 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:28Delegate 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:45Trainer 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.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
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. |
