Forum Discussion

Philip's avatar
Philip
Frequent Visitor
10 years ago
Solved

Can a report be created using multiple datasets?

Hi all, Can a report be created using multiple datasets?
Need Help
  • cbailiss's avatar
    cbailiss
    10 years ago

    No, a report can only be based on one data set.  

     

    A data set is one complete data model, with relationships between the tables in the model.  A model also often contains measures covering multiple tables, etc.  

     

    (A report spanning multiple datasets would be limited since no relationships would exist between tables in different models).

     

    A data set can however contain multiple queries, i.e. can be based on multiple data sources.

     

    Chris

Erik_N's avatar
Erik_N
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

This feels like a bug...    

 

If I have a dataset from a tool like OMS, and I have a dataset from my CMDB (stored in Azure SQL DB), and I want to have a report that shows OMS values with the CMDB relationship over top, the common thread would be the hostname(s).   Currently this can't be done.