cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CaptainRyan Frequent Visitor
Frequent Visitor

PowerBi Refresh Failing "This native database query isn't currently supported. Table: XXX"

Hello all,
 
I am using PowerBI to display various dashboards, based on reports, that get data from a SQL database and use stored procedures to pivot on the data when the user changes dropdowns in the dashboard. Some, but not all, dashboards and reports stopped refreshing suddenly around the same time on July 3rd and the error "This native database query isn't currently supported. Table: XXX" has cropped up.
 
I have confirmed that the underlying SQL database is still receiving data. I have also tried refreshing credentials and repinning the dashboard. The stored procedures seem to execute successfully against the database. So far, nothing works and my dashboards are stuck showing data from July 3rd and earlier.
 
Has anyone encountered an issue like this and, if so, what were the steps taken to resolve it?
 
Cheers,
Ryan

2 REPLIES 2
ajjodar Visitor
Visitor

Re: PowerBi Refresh Failing "This native database query isn't currently supported. Table: XXX&q

Hi @CaptainRyan ,

 

I am getting same problem after installing the last gateway update.

Have you fix the issue? I appreciate your help!

 

Kind regards,

Antonio

CaptainRyan Frequent Visitor
Frequent Visitor

Re: PowerBi Refresh Failing "This native database query isn't currently supported. Table: XXX&a

Hi @ajjodar ,

 

Unfortunately, the issue is still affecting us. One mitigation we discovered is to not run the stored procedures but to directly use the query instead. So far, we have been unable to use stored procedures.

 

Cheers,

Ryan

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 96 members 1,811 guests
Please welcome our newest community members: