Can I update a dataset when one data source cannot be refreshed?

[Anonymous]

Assume I have a dataset in the Power BI Service and it has three datasources in it. I set up a scheduled refresh, but unfortunately one of these data sources is unavailable.

However, I do want the other two data sources to be refreshed. Is this possible? Or does Power BI not update anything at all?

[venal]

@Anonymous 

in this scenario, you will get dataset refresh error message.

So please evaluate with the right credentials with other 2 data sources for the successful refresh to the latest data.

Path:- Workspace(Sample) >> Datasets (tab) >> Gateway Connection >> Add to Gateway

          Workspace(Sample) >> Datasets (tab) >>Data Source Credentials >> Click "Edit Credentials" and evaluate it.

If you have any queries, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[Anonymous · Accepted solution]

Hi @Anonymous ,

In Power BI Service, the refresh is a full refresh only so, It is not possible to refresh specific tables in a single dataset. To reduce refresh time in Power BI Service, import required columns and rows to Power BI and optimize data model.

Best Regards,
@Mail2inba4

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.