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

LuizAGM50 · ‎12-26-2022

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 · ‎12-26-2022

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.

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

LuizAGM50 · ‎12-27-2022

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

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