Forum Discussion

mirajvsen's avatar
mirajvsen
Regular Visitor
8 years ago

Handling datasource errors

Hi,   Is there a way to handle errors in the datasource like the following: Requirement: I have multiple datasource in multiple domains and would like to have a common power bi file to conn...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi mirajvsen

How does this error happen? What steps have you done?

Do you use Windows credentials or SQL login to connect to the target SQL Server from Power BI Desktop? 

You could follow steps in the blog to configure SQL Server to allow remote connections.

 

Best Regards

Maggie

mirajvsen's avatar
mirajvsen
Regular Visitor
8 years ago

Hi v-juanli-msft,

 

Thank you for the response...

I understand that this error is caused due to a connectivity issue and I would like this to be handled using a "try" or some other method that exists in power BI. 

My idea is to use the same power BI desktop file in different networks. 

 

Please have a look at the following:

DataSourceDomain
Source1Domain1
Source2Domain1
Source3Domain1
Source4Domain2
Source5Domain2
Source6Domain2

 

I have an append query which will append the results from all the above mentioned datasources.

 

The issue is,

When I am in Domain1 and I refresh the power bi file, the append query tries to refresh all the datasources and the refresh fails for the datasources created in Domain2 and whole refresh process fails, because there is no connectivity to the sources in Domain2.

 

Is there a way to overcome this situation by either configuring the power bi desktop to ignore the errornious sources in the append query or handle the error using a "try" or any other methods?