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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
HI all,
i want to took the POWER BI REST API as Datasource for a Dataflow, but it doesn´t work. I don´t find any topic for this, hopefully i don´t overseen something.
Currently we are saving all Activities and other Data via Power Automate in Dataverse but the Flows are Running more then one hour. I hope Dataflows are much faster?!
What i´ve done already:
1. Created a App registration in ADD
2. Try to create a Dataflow and Source = Web API
For Example:
https://api.powerbi.com/v1.0/myorg/admin/apps?%24top=100
3. Try to access with Organizational Account or service principal with client secret and so on
But allways an Error accured:
What i just wondering about is, when i want to configure a new connection for Web API Power BI says the following:
Currently, these cloud connections are not supported by Dataflows, Dataflows Gen2 and Datamarts. To create personal cloud connections for these experiences, use the Dataflows or Datamarts editor in "retrieve data".
Is it generally not possible to use a Web API as Datasource for a Dataflow? Are there any other Options for Dataflow Gen2?
Anyone can help or got an idea?
Solved! Go to Solution.
You will likely find that dataflows are unable to use AAD auth.
Use this one instead and feed a dataset. PowerBIRESTAPI/README.md at master · migueesc123/PowerBIRESTAPI · GitHub
You will likely find that dataflows are unable to use AAD auth.
Use this one instead and feed a dataset. PowerBIRESTAPI/README.md at master · migueesc123/PowerBIRESTAPI · GitHub
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.