Bug Rebinding Report with Power BI API

[Slim_Farhani]

Hello,

I have a Power BI Desktop Report with a live connection to Dataset A.

I've published the report to Power BI Services and then rebinded the report to Dataset B.

When I verify on the lineage, I find that my report is binded to the Dataset B.

But when I download the report from Power BI Services and open it on Power BI Desktop, I find that the connection is always set to Dataset A.

It 's like the rebinding of the report is taken into consideration only on Power BI Services and not on the Desktop version.
I'm at your disposal for any further questions.

Thank you.

Best regards,

Slim FARHANI

[v-yanjiang-msft]

Hi @Slim_Farhani ,

Could you please describe how do you rebinded the report to Dataset B?

Best regards,

Community Support Team_yanjiang

[Slim_Farhani]

Thank you for your quick reponse.

I rebinded the report with the following PowerShell code :

$reportId = "Report_Id"

$datasetId = "DatasetB_Id"

$wsId = "ReportWorkspace_Id"
$postParams = @{
"datasetId" = "$datasetId"

}

$jsonPostBody = $postParams | ConvertTo-JSONInvoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$wsId/reports/$reportId/Rebind" -Method Post -Body $jsonPostBody -Verbose

Best regards,

Slim FARHANI

[Anonymous]

Hi @v-yanjiang-msft @Slim_Farhani 

Even I have the same issue regarding rebind report. But I somehow did it using some customized way of changing the connections file at the background.

But, below scenario is still not working and that scenario is our particular use case.

When I try to change the connections file at the background for a live connected report and dataset is XMLA updated it is not able publish back to the Power BI service using POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/imports?datasetDisplayName={datasetDisplayName}&.... 

But the same case is working for normal live connected reports which are not XMLA updated.

Note: Connection files differ in both the cases.

Please let me know how can we reolve the first use case when dataset is XMLA upadted.

Best regards,

Shyam Kumar