Forum Discussion

LuizAGM50's avatar
LuizAGM50
New Member
3 years ago

Transform data button disabled - for data set loaded by MS Forms pushed by API at PB online

Hi Fellows!

Happy Christmas and Great New Year!

 

I can load but I can´t transform data at Power Query because the button is disabled. How to fix it?

My dataset was loaded by MS Forms and pushed by API at PB online.

I appreciate any tip or solution!

 

Cheers, Luiz

Need Help

2 Replies

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    3 years ago

    Hi LuizAGM50 

     

    You are probably using Live connection or Direct query that's why this is disabled or you are using any pre-existing dataset. These options are disabled as you cannot edit or modify the published dataset.

     

    • LuizAGM50's avatar
      LuizAGM50
      New Member
      3 years ago

      Hi AnkitKukreja, thank you very much for your reply!

      I had supposed the pushed dataset from API could be transformed.

      Anyway, I still looking for how to transform API streaming dataset at Power Query?

      All the best,

      Luiz