Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
epiphanied
New Member

Power Query won't load into power bi

When importing and transforming data from power bi, using power query, I changed the imported table name. After finishing all data transforming and loading back into power bi, I get an error about the table name change. Power bi gives no option to go back into the power query editor to fix it as all I have is two options, 'Apply changes' or ' Discard changes' . 'Apply' results in the error and 'Discard' causes me to lose all my work in power query. I cannot believe there's no way back to fix the query. Please advise what I'm missing?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@epiphanied , From Home Tab-> Transform Data -> Transform Data should allow you to open it

 

Or try to add something new and use transform data, not load data, you should able to reach power query and edit query again

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
epiphanied
New Member

Yes this! I just had to go into Transform Data again to have a look at the query problems and fix. Thanks amitchandak for the advice.

amitchandak
Super User
Super User

@epiphanied , From Home Tab-> Transform Data -> Transform Data should allow you to open it

 

Or try to add something new and use transform data, not load data, you should able to reach power query and edit query again

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.