Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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
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.
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
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 11 | |
| 7 | |
| 6 | |
| 6 | |
| 6 |