Forum Discussion

khisla's avatar
khisla
Helper II
1 year ago
Solved

transform data an load option not showing - just ok

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

I just see ok

Why is this?

 

 

 

  • 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 |

  • 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.

6 Replies

  • 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 |

  • 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?

     

    • SacheeTh's avatar
      SacheeTh
      Resolver II

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

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

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support

    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.