Forum Discussion
Importing .pbix files using Rest API and Microsoft.PowerBI.Api package fails with no error details
Thank you, v-aatheeque
We've managed to figure out the issue.
This was rather interesting case. Applying to the API using SDK package (the one mentioned in the title, Microsoft.PowerBI.Api) returned just import state failed, no error details in that response.
But we've called the same api through 'REST API Try It' tool. There was a difference in account used - it was not service principal, but personal admin account and that one did produce a result with error details including error code: DMTS_PowerBIDataMovementUserDatasourceExceededLimit
It appeared to be and issue with reaching maximum allowed number of datasources (we'e hit 1000). As soon as we removed some reports and datasources subsequently, api returned to normal operation.
Thank you, v-aatheeque
We've managed to figure out the issue.
This was rather interesting case. Applying to the API using SDK package (the one mentioned in the title, Microsoft.PowerBI.Api) returned just import state failed, no error details in that response.
But we've called the same api through 'REST API Try It' tool. There was a difference in account used - it was not service principal, but personal admin account and that one did produce a result with error details including error code: DMTS_PowerBIDataMovementUserDatasourceExceededLimit
It appeared to be and issue with reaching maximum allowed number of datasources (we'e hit 1000). As soon as we removed some reports and datasources subsequently, api returned to normal operation.
Hi NazarStasiuk ,
Thank you so much for the update ,we’re glad to hear the issue has been resolved on your end! We really appreciate your time and effort in closing the loop.
If any of the replies in this thread helped along the way, please consider marking the most relevant one as the accepted solution. This helps others in the community who may face similar challenges to find answers more efficiently.Also, feel free to share your own solution in the thread it would be valuable for others who might benefit from your experience.
Thank you again for your kind cooperation and contribution to the community!
