title: How to fetch Physical SQL Query from a Semantic Query in RDL file?
body: <p>How to fetch Physical SQL Query from a Semantic Query in RDL file?<br>
  We have some following steps to go ahead while extracting the Semantic Query from RDL</p>
  
  <ol>
  <li>Extract the Semantic Query from RDL file</li>
  <li>Validate against the Semantic Model XSD </li>
  <li>Parse and Transfrom Semantic Query into a structure where we will be able to generate Physical SQL from </li>
  <li>Execute the conversion process to get physical query</li>
  </ol>
  
  <p>We accomplished step 1, We were able to Extract the semantic query from RDL and store it in XML</p>
  
  <p>Question 1: </p>
  
  <p>For step 2, Validating against the XSD. XSD path is <a href="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd" rel="nofollow">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd</a> and our XML is extracted from RDL. The Semantic Model XSD mentioned above has some import namespace to DataSourceView.XSD. Can anyone suggest how and where can I get DataSourceView.XSD?</p>
  
  <p>Question 2: </p>
  
  <p>For Parse and Transform the Semantic Query, do we need to create an XML parser in C# or does any API which can perform this.</p>
  
  <p>We can't Run the RDL file against Reporting model, because our requirement is to get the Physical SQL not the Dataset. </p>