Solved: Problem: Changing Data Structure in Excel after Im...

Hengqiiiiii · ‎09-26-2018

Hi folks,

Currently, I have imported some data from a worksheet to Power BI and everything goes well. However, I just realize that the worksheet needs some improvement. I add more data into the worksheet and the layout is also changed. After all the improvements, PowerBI file is not able to refresh the data. Is there any method to solve the problem?

Thanks in advance!

v-chuncz-msft · ‎09-26-2018

@Hengqiiiiii,

You may modify code in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎09-26-2018

@Hengqiiiiii,

You may modify code in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Problem: Changing Data Structure in Excel after Importing the Data

Helpful resources

Power BI Dataviz World Championships

Power BI Monthly Update - December 2025

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

FabCon is coming to Atlanta