Skip to main content

Power BI

New

Report is cleared when updated dataset is published (bug fix)

Vote (21) Share
Melissa Coates's profile image

Melissa Coates on 11 Nov 2015 00:35:54

Reports in the web that are authored independently of the dataset are far too sensitive to changes when a new dataset is published. I would expect the report to 'break' for removed columns, renames, etc. However, the entire report is lost if anything in the model seems to change. Background below.

We have a data model with ~20 tables. Since users can edit reports in the Power BI Service, we had the idea of publishing the model by itself and then using the web for report creation (we thought by decoupling the model from the reports in PBI Desktop that we could potentially overwriting newer report changes made in the web when just a model change has occurred). However, this isn't working out. Anytime a change occurs and the dataset is re-uploaded, reports that referred to *anything* related to the table updated seem to be wiped out in the Service.

Example 1: I changed Member ID back to being non-aggregatable (separate issue-I won't digress) and republished the model. A report uses a concatenated version of that column which had the aggregation setting changed. That report canvas was cleared completely in the Service.

Example 2: I added 2 new calculated columns in a table. Though nothing was removed or changed, other columns in that same table were used in a report. Again, that report canvas was cleared completely in the Service.

Comments (4)
Melissa Coates's profile image Profile Picture

6852ed5a ca53-4c16-9370-c627dd20b7b2 on 16 Aug 2020 03:51:37

RE: Report is cleared when updated dataset is published (bug fix)

Following up with more info...We discovered through some testing that this only affects what we're calling the 'default' report -- the report that gets published with a model even if the report is blank. If we are very careful to *always* delete that report, never rename or reuse it, and create separate reports in the Service, the issue is not as prevalent.

Melissa Coates's profile image Profile Picture

6852ed5a ca53-4c16-9370-c627dd20b7b2 on 16 Aug 2020 03:51:36

RE: Report is cleared when updated dataset is published (bug fix)

After more thought on this issue, it would offer great value if we could publish the 'dataset only' from PBI Desktop to the Service. That capability would be extremely helpful and essentially solve this entire issue.

Melissa Coates's profile image Profile Picture

6852ed5a ca53-4c16-9370-c627dd20b7b2 on 16 Aug 2020 03:48:28

RE: Report is cleared when updated dataset is published (bug fix)

Following up with more info...We discovered through some testing that this only affects what we're calling the 'default' report -- the report that gets published with a model even if the report is blank. If we are very careful to *always* delete that report, never rename or reuse it, and create separate reports in the Service, the issue is not as prevalent.

Melissa Coates's profile image Profile Picture

6852ed5a ca53-4c16-9370-c627dd20b7b2 on 16 Aug 2020 03:48:27

RE: Report is cleared when updated dataset is published (bug fix)

After more thought on this issue, it would offer great value if we could publish the 'dataset only' from PBI Desktop to the Service. That capability would be extremely helpful and essentially solve this entire issue.