We use the Power BI API for the deployment of Power BI Datasets and Reports with LiveConnect to Workspaces in powerbi.com. We have different users for our development, acceptance and production environments. First, we deploy the dataset from a pbix-file using the API method PostImportWithFileAsyncInGroup. Then we deploy the report from another pbix-file using the same method. Finally we bind the report to the new dataset using RebindReportInGroup. This works fine for our development environment, but in other environments we get a PowerBIModelNotFoundException while deploying the Power BI Report, since the pbix-file has a connection to a deployed Power BI Dataset, were the identity is not permitted to access. So it would be great to add a parameter to PostImportWithFileAsyncInGroup to ignore the invalid reference and publish the report anyways, so we can call RebindReportInGroup afterwards. Another solution would be to add a dataset ID as optional parameter to PostImportWithFileAsyncInGroup that calls RebindReportInGroup internally.
4 Comments
- Mederick_BossanNew Member
This is a must HAVE for CI/CD automation using git flow, please !
- numa1New Member
Also interessed!! Thanks
- Mederick_BossanNew Member
Please merge with https://ideas.powerbi.com/ideas/idea/?ideaid=87c44269-a8cc-ea11-bf21-501ac5249847
which is exactly the solution needed !
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Blocker: Purview must scan Fabric Warehouse tables/columns or we will deprecate Purview
Purview + Fabric Warehouse ≠ enterprise‑ready governance. In our environment, the Fabric Warehouse is the system of record, but Purview can only catalog the warehouse container—not the tables or co...Joshua_Hernande7 hours agoNew MemberNew180Views1like1CommentPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes16 hours agoNew MemberNeed Clarification198Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v16 hours agoCommunity ChampionNeeds Votes37Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_16 hours agoNew MemberAbandoned27Views0likes2Comments