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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

New Member

Data refresh issues with SQL DB Auditing

Hi all,


I have set up auditing in my Azure SQL database, and have successfully connected the audit logs with Power BI following the instructions here. However, most data refreshes - scheduled and on demand - fail. In particular, I have been consistently running into the following error for the past few days:


PersonalGateway_DataSourceKindLabel: AzureTables
Data source error: We couldn't parse OData response result. Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.


Does anyone have any insight into this? 


Thank you!


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors