We dedicated a month to automating the deployment of our client's reports and apps, including interactive PowerApps. We couldn't use PowerBI pipelines because the PowerApps visual doesn't support programmatic changes to the app reference when deploying to different stages. As a result, we had to modify the PowerBI PBIX file directly. Our goal was to deploy the entire stack seamlessly.
Navigating this process was challenging due to limited API documentation, especially for certain aspects of the PowerBI cloud infrastructure, like the Tenant cluster. After overcoming countless obstacles, we hit a brick wall: there's no API to automate PowerBI App deployment. After a month of effort and escalating costs, our frustration is palpable. The absence of such a critical feature makes us reconsider our initial decision to use Azure and PowerBI as our primary solution.
