Skip to main content

Power BI

New

Publish a report without updating Dataset

Vote (78) Share
's profile image

on 30 Nov 2017 20:15:34

When a report is published from PowerBI Desktop, there is no way to publish without publishing the dataset as well.

This forces me to update the dataset again on my Desktop (which sometimes takes a lot of time) before publishing it.

Why can't I publish the new report and have it use the dataset that is already uploaded?

Comments (4)
's profile image Profile Picture

6528283e d94a-4c47-9876-c264525b9c7a on 06 Jul 2020 00:00:10

RE: Publish a report without updating Dataset

This option is in Power BI. Import data with POWER BI dataset service. When publishing it won't create a new datasets. Also you cannot refresh the dataset from the desktop POWER BI app.

This option enable to create reports on a desktop POWER BI app with no change in dataset. Perfect!

's profile image Profile Picture

9c9c3bea ab60-43af-abf7-0eb422f20f60 on 05 Jul 2020 23:42:48

RE: Publish a report without updating Dataset

I understand the potential workaround of referencing a dataset already on the service, but this problem does need to be addressed. If I decide to only change the color on a visualization (on the souce .pbix, not editing in the service), why do I need to replace the whole dataset (especially when the one I loaded into Power BI Desktop may be older than the one on the service using a gateway connection).
It also is a "wonky" user experience to have the extra "Replacing dataset" pop up when publishing - one saying "Do you want to replace the existing dataset with this one?" with only the options of "Replace" or "Cancel". The answers should be "Yes" or "No" based on the question.
So, if the workaround of using a pre-existing dataset and recreating the pbix for a report change is going to remain, can we at least change the question on the "Replacing dataset" pop up to avoid implying that there is another option to publish WITHOUT replacing the dataset?

's profile image Profile Picture

4d26fecd 60fd-4b24-82db-5ab6809c67c6 on 05 Jul 2020 23:10:00

RE: Publish a report without updating Dataset

The problem with that is that PowerBI Service has a ram limit of 1GB and the reports that connect directly to VertiPaq work fine.

's profile image Profile Picture

81ce4dee 9a3a-4f38-98cd-2bc49c0c5fa2 on 05 Jul 2020 23:06:30

RE: Publish a report without updating Dataset

I get around this by building a dataset report (the delete the report) . Then I make new report only views with a direct connect to my data model in power bi service. That way you can have multiple reports hinged off one dataset and can just publish the report on its own