transform data an load option not showing - just ok

I used the Excel option

Hello khisla ,

Could you share your M code? İf it is not sensitive.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

Are you facing the same issue if you use another excel file for loading data?

Hi khisla,

We sincerely appreciate your query submitted through the Microsoft Fabric Community Forum.

1. Kindly update your Power BI Desktop to the latest version to address any compatibility issues. Updates typically resolve bugs and enhance functionality. Please note that older versions may not support the Transform/Load functionalities.
2. Ensure that your user account has the necessary permissions to edit or transform data from the source, as this may influence the options available.
3. Clear the cache and restart Power BI Desktop to refresh its application state and verify if the problem is resolved.
4. To verify if this is a temporary glitch, save your work and restart Power BI Desktop to check if the options reappear. If the issue persists, please consider uninstalling and reinstalling Power BI Desktop to resolve potential file corruption or settings issues.

Should you find this response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will assist other community members encountering similar issues.

Thank you.