Forum Discussion

m_chan's avatar
m_chan
Regular Visitor
2 years ago
Solved

Query won't apply to Desktop

Hello. I've been running into an issue lately where whenever I make a change in Power Query, nothing happens when I hit the "Apply" button to get any changes applied to the Desktop/Dashboard. Even if...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi m_chan ，

    1. Ensure you have the latest version of Power BI Desktop installed. Microsoft frequently releases updates that fix known issues.
    Download Power BI Desktop from Official Microsoft Download Center

    2. Verify that the data source credentials are correct and that you have the necessary permissions to edit and apply changes.
    3. Look for any possible errors in your queries that might prevent the application from applying the changes. Even if you don't see an error message, there could be warnings or issues within the Applied Steps in Power Query.
    4. Sometimes, Power Query may have pending changes that prevent successful application. Look out for any yellow warning bars indicating pending changes. 


    5. Clear the cache from Power BI.
    6. Try replicating the issue with a different Power BI file or a new one. This can help determine if the issue is file-specific.

    If you continue to experience the issue after trying these steps, it may be helpful to gather more detailed information about your situation. For instance:

    Does this happen with all queries or only specific ones?
    Are there any specific types of changes (e.g., adding columns, changing data types) that are not being applied?

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi m_chan ，

1. Ensure you have the latest version of Power BI Desktop installed. Microsoft frequently releases updates that fix known issues.
Download Power BI Desktop from Official Microsoft Download Center

2. Verify that the data source credentials are correct and that you have the necessary permissions to edit and apply changes.
3. Look for any possible errors in your queries that might prevent the application from applying the changes. Even if you don't see an error message, there could be warnings or issues within the Applied Steps in Power Query.
4. Sometimes, Power Query may have pending changes that prevent successful application. Look out for any yellow warning bars indicating pending changes. 


5. Clear the cache from Power BI.
6. Try replicating the issue with a different Power BI file or a new one. This can help determine if the issue is file-specific.

If you continue to experience the issue after trying these steps, it may be helpful to gather more detailed information about your situation. For instance:

Does this happen with all queries or only specific ones?
Are there any specific types of changes (e.g., adding columns, changing data types) that are not being applied?

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group