Problem: Changing Data Structure in Excel after Importing the Data

[Hengqiiiiii]

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 · Accepted solution]

@Hengqiiiiii,

You may modify code in The Advanced Editor.