Data get mixed up between different Intune Data Warehouse

[Micaelaman]

Hello,

As a multi service provider we are monitoring different Intune installations with Power BI. It is done by connection to Intune Data Warehouse. However, if two of these Intune installations has the same URL (same datacenter?) to the data warehouse the data get mixed up. 

Ex 

Customer1

URL: https://fef.msub05.manage.microsoft.com

credential: [email protected]

Customer2

URL: https://fef.msub05.manage.microsoft.com

credential: [email protected]

Customer3

URL: https://fef.msub06.manage.microsoft.com

credential: [email protected]

Data will be mixed up between Customer1 and 2, but not with customer3.

Any ideas?

[eriwol1]

Did you find a solution to this? I'm having the same problem and it's really annying not been able to report for differant customers.

[Anonymous]

@Micaelaman,

Do you create the Power BI report in a single PBIX file by signing in the OData URL using different accounts? Do you find mixed data in Power BI Service or Power BI Desktop?

Regards,
Lydia

[Micaelaman]

Yes, I have created the reports in Power BI Desktop and then publish them to Power BI Service.

There are different PBIX-files.

As mentioned earlier we monitor different Intune installations (different companies) so the reports are almost identical.

The only thing that is different is the login account to the Intune Data Ware House. The URL is the same on the reports that get mixed up. We can not change the URL as it is created by Microsoft when Intune tenant is created.

Regards

Micael