Forum Discussion

Micaelaman's avatar
Micaelaman
Frequent Visitor
8 years ago

Data get mixed up between different Intune Data Warehouse

 

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?

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      Micaelaman
      Frequent Visitor
      8 years ago

       

       

      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

  • eriwol1's avatar
    eriwol1
    Regular Visitor
    4 years ago

    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.