Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ausrine
Frequent Visitor

Exclude data from refresh

Hi all, 

I've made a report on Power BI Desktop and I have excluded one SQL dataset from report refresh.

As I understand, once I upload the report to Power BI Service and refresh it, it refreshes all data sources (even the one I excluded). How can I keep that certain dataset in Power BI Service excluded from refresh?

 

Thanks, 

Ausrine

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@ausrine

 

As you publish your .pbix onto Power BI Service, it will replace the dataset (for entire report) existing on Power BI Service. If you remove the SQL dataset from .pbix, it will not include this data source on Power BI Service after you publish this report. So data refresh will not cover this SQL data source. You can also delete that SQL data source under "Manage Gateway". 

 

Regards

View solution in original post

2 REPLIES 2
v-sihou-msft
Employee
Employee

@ausrine

 

As you publish your .pbix onto Power BI Service, it will replace the dataset (for entire report) existing on Power BI Service. If you remove the SQL dataset from .pbix, it will not include this data source on Power BI Service after you publish this report. So data refresh will not cover this SQL data source. You can also delete that SQL data source under "Manage Gateway". 

 

Regards

It works, thank you @v-sihou-msft

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors