What are the blank ligns in the Microsoft 365 Usage Analytics report?

[Anonymous]

Hello,

I am actualizing a PBI report that is based on the monthly data the PBI Report "Microsoft 365 Usage Analytics report" is providing for my tenant.
Problem is, since a few months, some blank ligns appeared in the datas :  there are UserId, some datas about the application used (Exchange, OneDrive...), however the columns "DisplayName", "UPN", "Department" and "Company" are completely blank.
But more problematic, some data columns are blank too, which causes a lot of issues in my own report that feed on them :

• SPO_TotalFilesSynched,
• SPO-TotalFilesViewed/Modified,

Would someone know what are these ligns refering to? And why is there blank cells on these data columns about SharePoint and not a "0"?

Thanks in advance.

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,

Community Support Team _Tang

[v-xiaotang]

Hi  @Anonymous

I export data from Microsoft 365 usage analytics report to excel, but I don't see such a blank.

So I guess this blank does not always appear. It may be caused by some operations.

If this kind of blank has no effect, I suggest filtering it out.

Best Regards,

Community Support Team _Tang

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