Forum Discussion
Automatic datastream, query not available
Dear all,
I am working with an automatic datastream via PowerAutomate. My dashboard in Power BI refreshes automatically if a form in ms forms is submitted. It works well, but I can't access Power Query or transform my data in Power BI.
But I have some columns in the form where more answer options are available. I splitted my column in power automate so that it is now a list of strings. I got stuck in power bi trying to seperate the values, because I need power query which is not available. I am quite new using this automatic scream. Can someone help me with this?
Thank you very much in advance!
Hi Anonymous ,
You must have an existing Dataflow with maker permissions to access the portal, and read permissions to access data from the dataflow.
For more information, please refer to:
Power Query Dataflow connector - Power Query | Microsoft Learn
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
You must have an existing Dataflow with maker permissions to access the portal, and read permissions to access data from the dataflow.
For more information, please refer to:
Power Query Dataflow connector - Power Query | Microsoft Learn
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.