Forum Discussion
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?
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
2 Replies
- amitchandak
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
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.
