I have a requirement where i need to fetch the powerbi dataset records into power automate, do i need to have powerbi pro license for this requirement? Mostly i will be using run a query against a dataset action from power automate?
also what level of permissions do I need to have on powerbi workspace?
If you published the report/dataset to the Power BI service, then you don't need a Pro license.
If someone else published the dataset, then you will need a Pro license (or premium per user).
You will need at least Read and Build permissions.
Please let me know if you need more help and mark this response as the answer to your question if it works for you.
Scott
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.