cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SreeY
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.

 

Thanks

Sree 

3 REPLIES 3
v-easonf-msft
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

 

SreeY
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.

ribisht17
Super User
Super User

@SreeY 

 

Please check https://community.powerbi.com/t5/Service/Unable-to-refresh-in-service-when-appending-difference/m-p/...

 

Thanks,

Ritesh

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

Announcements
Carousel_PBI_Wave1

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