Dataset Refresh Failed: Data source errorObject reference not set to an instance of an object.

[Pratshin]

Hi Team, 

Suddenly from friday 04-03-2022 we have error in dataset refresh with below message for all dataset.

We are using Azure SQL server Data source and Vnet data gateway for private connectivity.

Option tried:

1. recreate data gateway cluster but same error

2. receate data source in gateway cluster same error 

3. enable public access on DB refresh working fine.

observation Issue with VNet Data Gateway. Could anyone please suggest.It's urgent production issue. 

Error Message:

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.Hide details
Data source errorObject reference not set to an instance of an object.. The exception was raised by the IDbCommand interface. Table: xxx Query.
Cluster URIWABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net
Activity ID3a17d72d-f637-4ae4-bd14-ba104a9f4aaf
Request ID699aad2e-91f1-2838-f95a-d9dd17b899eb
Time2022-03-07 08:11:41ZCopy

[v-xiaotang]

Hi @Pratshin

Does this error only appear on the service? If the refresh operation is performed in Power BI Desktop, will this error occur?

FYI:

Object reference not set to an instance of an obje... - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

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

[Pratshin]

Yes Refresh works fine on Power BI Desktop

[Pratshin · Accepted solution]

Hello,

Issue has been fixed after Microsoft applied patch for this issue. Thanks you!

[Pratshin]

Did anyone faced this error recently?