Ask Your Question
2

What is the process of extracting information from a Power BI dataset and transferring it to an Excel table while also modifying all the headers?

asked 2021-06-22 11:00:00 +0000

pufferfish gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-12-24 09:00:00 +0000

djk gravatar image

The process of extracting information from a Power BI dataset and transferring it to an Excel table while also modifying all the headers can be done in the following steps:

  1. In Power BI, select the dataset that you want to export to Excel.
  2. Click on the "Export" button in the "Home" tab and select "Summary Data".
  3. Choose the "Excel Workbook" option and select the location and filename where you want to save the file.
  4. In Excel, open the exported file.
  5. Modify the headers as desired, by clicking on each cell and typing a new name.
  6. Save the file with the new headers.

Alternatively, you can use the "Get Data" feature in Excel to connect to the Power BI dataset and import the data directly while also modifying the headers. This can be done using the following steps:

  1. In Excel, select the "Data" tab.
  2. Click on "Get Data" and select "From Power BI".
  3. Enter your Power BI credentials and select the dataset that you want to import.
  4. Use the data transformation features in Excel to modify the headers as desired.
  5. Save the file with the new headers.
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-06-22 11:00:00 +0000

Seen: 9 times

Last updated: Dec 24 '21