transform data an load option not showing - just ok

[khisla]

I do not see the transform data or load option showing.

I just see ok

Why is this?

[khisla · Accepted solution]

I used the Excel option

[uzuntasgokberk · Accepted solution]

Hello @khisla ,

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

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

[Omid_Motamedise · Accepted solution]

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

[v-pnaroju-msft · Accepted solution]

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.

[Omid_Motamedise · Accepted solution]

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

[uzuntasgokberk · Accepted solution]

Hello @khisla ,

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

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

[khisla · Accepted solution]

I used the Excel option

[SacheeTh]

Anyway you can do the transpormation after Click on OK, as usual.
I think not much of a biggie

[SacheeTh]

Hi @khisla,

if you use the Excel option as bellow, it should not be show the transform option, would you able to share the Mcode prior to this step?