Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The new Update Datasources REST API is great but doesn't work if an imported table contains a merge queries step to join to another table.
I have reproduced with a couple of test tables and two PBIX files: one includes a merge and the other doesn't.
It is identified as a bug and the product team is working on a fix. Thanks again for your reporting. 🙂
@rlaveycal wrote:
The new Update Datasources REST API is great but doesn't work if an imported table contains a merge queries step to join to another table.
- The call to /updatedatasources returns success
- The call to /BindToGateway returns success, using a gateway with a data source for the new DB server/database
- The refresh fails with "Invalid connection credentials.". The underlying error message indicates that the original server/database values are being used.
I have reproduced with a couple of test tables and two PBIX files: one includes a merge and the other doesn't.
Thanks for your reporting. I can reproduce that issue and I've reported this internally. I'll post back once there comes any update.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |