Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Power Bi Service not Appending results from Import and DQ tables

Hi, I have one import Query table, and another Direct Query table. And I Appended the data from both Import and DQ tables. I see the both tables have been appeded power bi desktop, everything looks good in Power BI desktop.  But, after I publish the dataset and refresh the data, the Append Query is not showing the data from DQ table, it showing only from Import table. To make sure the DQ is giving latest data, I created a spearate page and I see the it is updating with latest data.  Why I am not seeing the same data in the Appended table in the Power BI server, even after I refreshed the page.


Appectiate your help.




Community Support
Community Support

Hi, @SreeY 

Are there any errors reported in the data refresh history?

When you click the 'Data Refresh',both data in direct query and import should be refreshed.

If the data is not updated, it is recommended to clear the browser cache and re-login to the service account before refreshing the report.


Best Regards,
Community Support Team _ Eason


Regular Visitor

Ritesh, In my case I don't see any thing like that. I have a premium capacity, and set it enterprise level. the 2 tables data coming from same database.

gurus- Any help appreciated.

Super User
Super User



Please check




Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!PL 300 Certification Videos 

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors