Power Bi Service not Appending results from Import and DQ tables

[SreeY]

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 

[v-easonf-msft]

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]

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]

@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