Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
My problem is right now when a report is uploaded/published to power bi web from desktop, and when the api is called to update the dataset behind this report , the report WASNT REFRESHED with the new dataset, which is in excel or csv format behind the pbix file published. Therefore using the PowerBI API, what are the steps that has gone wrong/insufficient for me. I am listing the steps below:
$powerbi = new PowerBI($rd->biusername, $rd->bipassword);
$dataset = $powerbi->GetDatasetByName($name);
$tables = $this->GetTablesFromFile("stats_v1", "/tmp/Power1to8.xlsx");
$rows = $this->GetRowsFromFile($name, "/tmp/Power1to8.xlsx");
$this->UpdateTablesDataTypes($tables, $rows);
$powerbi->DeleteRows($dataset['id'], $table['name']);
$powerbi->PostRows($dataset['id'], $table['name'], $rows[$table['name']]);
$reports = $powerbi->GetReportsByDataset($dataset['id']);
$powerbi->UpdateReportContent($report['id'], $dataset['id']);
Therefore seeking kind souls to advise whats wrong above or anyting insufficient so as to be able to allow me to refresh my data for the power bi file
Thanks
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 7 | |
| 4 | |
| 3 | |
| 3 |