Share via

Power BI: Edit imported data / Add Headline from other imported data (not manually created table)

Krejo 21 Reputation points
2021-02-05T19:20:39.34+00:00

Dear all, I am wondering how to edit imported data in the Editor Area.
The reason is, that my imported data don' t contain any Headline. Theses headlines are part of an other file/data, which is also added to the power BI file.

Regrettably power Bi seems to only allow to edit tables which are manually created, by clicking the gearsymbol next to the source-field.
So editing imported data seems to be forbidden?

My Aim is to copy the headlines, which are mentioned in one row and to paste this to an the imported data as new row, which can be used afterward as headline.

Till now I just have the possibilty to click each column to typ the headline in. The Problem is, that I have to do this for 200 columns.
Is there any solution to copy ans paste a row?

Thx for your help.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,794 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Krejo 21 Reputation points
    2021-02-05T22:53:47.387+00:00

    Thank you very much for your promp reply.
    Nevertheless, I suggest that you are an expert according to power BI. Maybe you know how to solve the mentioned technical problem. So to edit an imported data-table and to copy and past the first row from one imported table and to paste it in the table to have the right headlines for the columns.

    Because this small problem is the key, if Power BI could have a huged impact for my work or to turn out being completly useless for the whole company.

    Thank you very much for your support.