Export summarized data is showing different results

[GoncaloAAlves]

Hello all, 
I have a PBI in which I have built a composite model using direct query and imported data. When exporting the results from PBI Service using the table in which i use both data sources, the results in the excel file from the collumn from the direct query do not match to what is visible in the PBI service and became the same as the collumn on the right (imported).

Example:

Net sales - Act -> Direct Query
Sales Fcst -> Imported 
 
Does anyone know the reason or even more important how to get the right data? Thank you very much in advance

[Anonymous · Accepted solution]

Hi @GoncaloAAlves ,

Was the data filtered or calculated before exporting?

At the same time, notice this limitation:

For more information, refer to this doc:

Export data from a Power BI visualization - Power BI | Microsoft Learn

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly