ability to Publish report without dataset inclusion

[SureshParis]

Hi Team

I have a report which was developed from many tables(around 40) so it is big dataset and refresh is taking around 45 minutes(we can't go for incremental refresh), already report is in Production.

If i get any changes in report, i used to do apply changes in UAT then will migrate to Prod, here the problem is,

when i migrate report from UAT to Prod , Prod dataset is replacing with UAT Dataset(at initially) then prod data is getting refreshing to that dataset,
So immediatly after publishing report into prod environment users seeing UAT data untill it refreshes prod data.

we should not load UAT data into Prod in our case, any way we can publish the report alone with changes we made to prod with out disturbing prod dataset.

Notes

report is in mixed mode (we have few direct query few import quries)
We though of connecting power bi dataset , but here we should not load data to desktop

Any thoughts on this please ?

Thanks,
Suresh

[Anonymous · Accepted solution]

Hi @SureshParis,

Have you tried to parameterize your connection string with the query parameter? They should suitable for reports who need to migrate the environment.

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev 

>>We though of connecting power bi dataset , but here we should not load data to desktop

You can enter the query editor and right-click on the query table to turn off the 'not include in refresh' option, then these query tables will not receive data in refresh operations.

Regards,

Xiaoxin Sheng