Forum Discussion
Connector Power BI dataflows (Legacy) vs Dataflows
Alright, after a lot of trial and error, we found out that we CAN have two datasources both using the new connector "Dataflows", one datasources connecting to Power Platform dataflows and the other connecting to Power BI Service dataflows, and at the same time.
The trick turned out to be to remove all original datasources involving dataflows everywhere (what a chase it was…), and recreate a lot of the dataflows from scratch again. I have to say that it is really diffcult (if possible) to comprehend what needs to be recreated and why. It seems as if some references to old datasources cannot be removed without a complete recreate of the dataflow in the following way (talking about Power BI dataflows now):
- Copy all queries from org. dataflow
- Create new dataflow
- Add a new query based on a datasource with the new Dataflow connector
- Then paste in the queries from the original dataflow
Spent 3 days!
Alright, after a lot of trial and error, we found out that we CAN have two datasources both using the new connector "Dataflows", one datasources connecting to Power Platform dataflows and the other connecting to Power BI Service dataflows, and at the same time.
The trick turned out to be to remove all original datasources involving dataflows everywhere (what a chase it was…), and recreate a lot of the dataflows from scratch again. I have to say that it is really diffcult (if possible) to comprehend what needs to be recreated and why. It seems as if some references to old datasources cannot be removed without a complete recreate of the dataflow in the following way (talking about Power BI dataflows now):
- Copy all queries from org. dataflow
- Create new dataflow
- Add a new query based on a datasource with the new Dataflow connector
- Then paste in the queries from the original dataflow
Spent 3 days!