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

[LuizAGM50]

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

[AnkitKukreja]

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]

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