Power BI Premium refresh failed and Power BI service doesnt offer enough information to troubleshoot

[NewUser777]

The error is pointing to CITY table which is hosted on Azure SQL db( data sample shown below)

Metadata in Tabular editor

City column properties in Tabular editor

Table defintion in SQL server 

Admin screen :

Error details:

Last refresh failed: 12/2/2022, 11:59:42 AM( EST)
There was an error when processing the data in the dataset.Hide details

Data source error:	Object reference not set to an instance of an object.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: City.
Cluster URI:	WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID:	90d47131-889b-453c-aa8c-0f9130f44fb8
Request ID:	753534d9-7254-078d-81c3-2c1fd3cc9f2a
Time:	2022-12-02 16:59:42Z

[v-jialluo-msft · Accepted solution]

Hi  @NewUser777 ,

You can refer to the following links:

View refresh summary - Power BI | Microsoft Learn

Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

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

[v-jialluo-msft]

Hi  @NewUser777 ,

According to your description, your problem is reporting an error when refreshing data.

You can view the data in the date column in the CITY table and whether there is any error data.

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

[NewUser777]

Thanks , I shall check that 

[NewUser777]

@v-jialluo-msft

I removed the table-city and deployed the model and was able to refresh . I looked at the dates column in the CIty table and it looked ok . 

I want to know if we can enable additional logging to see the actual error recorded by PowerBI service as the generic error doesnt help.

[lbendlin]

Please show the relevant Power Query code.