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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors