Exporting to Excel - Incomplete Information

[Andvil]

Hello,

I have a report that I usually export from PBI Services and then to Excel as an xls file. I have created some relationships between three different tables (Suppose employees, agencies and main table in this example). Data from employees and agencies table gets paired with the data from the main table throught a "key code", and not neccessarily all the infromation from the main table is matched with the employees and agencies table. Therefore, some information from the main table might not have an employee or agency assigned.

The problem is, when I export from PBI Services to Excel, it only exports the data that has an employee or an agency assigned. I want to see all the information, I have enabled the "show items with no data" and when I export, the data with no employee or agency assigned is exported, but the weight and number of items is blank in the data that has not been assigned an employee or agency. When I don't include agency and employee, same data is exported but the items and weight information that was in blank now has the numbers. Also, the information I export is under the PBI services limit, so this is not a reason for the problem.

I have realized that when I do not include the employee or the agency in the visual, when exporting, my excel has all the information and the total sum of Weight and Items match the sum in the PBI visual. When adding the employee or agency information in the visual and exporting to excel, only the data with employee or agency assigned is exported, leaving the information that is not paired out of the export file.

A community member told me that I should raise a support ticket for further investigation, and I would like to know if someone else has the same issue.

I have an example to show this in my Get Help with Power Bi Service post "Exporting to Excel - incomplete information".

[v-chuncz-msft]

@Andvil 

You may take a look at link below.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data#exporting-data

[Andvil]

Hi @v-chuncz-msft ,

Thank you for replying, I read the article but has not solved my problem, thus it helped me to understand better the show blank data option. I appreciate it.

When I do not enable the "show blank data", my visual is like this one:

See that from the 668 sales, only 458 have an employee assigned. I need to see the other 210 sales even though they do not have an employee assigned.

When I enable the "show blank data", my visual is this one:

See that it still shows 458 sales from the 668. By enabling the "show blank data", it shows the available employees but it still does not show the remaining 210 sales that are not assigned to an employee. And when I export to excel, it only exports the 458 sales, whereas I want all the sales where the 210 sales that are not assigned can have a blank in the employee field.

Is this possible?