PowerBI Report Only with No Access to source Dataset

[benjaminchouraki]

Hello,

I would like to publish Master Dataset with connected Reports Only PBIX (Live Connection to master dataset) in terraform.

Master Dataset PBIX publish correctly.
When I want to publish my reports (pbix files) I cannot update dataset connection.
My reports keep old Master Dataset connection in my DEV Environnement or Demo Tenant.

If my service account does not have access to my DEV Environnement I have the following exception :

Error: Post "https://api.powerbi.com/v1.0/myorg/groups/995f59b1-1667-4c8b-8b9f-d386bb234065/imports?datasetDisplayName=TAD-EN-3.0&nameConflict=CreateOrOverwrite": status code '400 Bad Request' with body {"error":{"code":"PowerBIModelNotFoundException","pbi.error":{"code":"PowerBIModelNotFoundException","parameters":{},"details":[],"exceptionCulprit":1}}}
│ 
│   on main.tf line 46, in resource "powerbi_pbix" "dataset_report-en":
│   46: resource "powerbi_pbix" "dataset_report-en" {

I would be good if we can add a dataset_id attribute in resource like the following code to rebind Live Connection:

resource "powerbi_workspace" "myworkspace" {
  name = "My Workspace"
}

resource "powerbi_pbix" "mydataset" {
  workspace_id = powerbi_workspace.myworkspace.id
  name         = "My Dataset"
  source       = "./dataset.pbix"
  source_hash  = filemd5("./dataset.pbix")
}

resource "powerbi_pbix" "myreport" {
  workspace_id = powerbi_workspace.myworkspace.id
  name         = "My Report"
  source       = "./report.pbix"
  source_hash  = filemd5("./report.pbix")
  dataset_id   = powerbi_pbix.mydataset.dataset_id
}

[vasyl-haievyi]

@benjaminchouraki , did you find any solution to it?