The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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