Report Builder - XSLT DataTransform
Hello, we are currently migrating current SSRS solution to PowerBI paginated reports and we are struggling with XSLT transformations applied in a few reports. Does anyone have experience with XSLT in PBI? When I open a current report in Visual Studio, its DataTransform property links to an XSLT file. When I run the report and export an XML file, XSLT transformations apply without any issues and XML file is generated. When I open the same report in PBI Report Builder, its DataTransform property links to the same XSLT file. When I run the report and export an XML file, it throws an error. Am I missing something? According to this Microsoft Docs page that also applies to PBI Report Builder, one should be able to perform XSLT transformations even in Report Builder. Unfortunately, I was not able to find any information on the web nor this community forum. Last but not least, I am describing a local experience as it is currently not advisable to carry on with migration to PBI Service. Supposing I am able to solve this issue with your help, how does one publish an XSLT file into PBI Service? Thanks so much for any info!
Creating a dataset on a Project Server based datasource
Hello, I am in the process of creating a number of dashboards based on MS Project Server data. First, I tried to build dashboards by having them connect directly to Project Server through the ODATA interface. This approach worked very well and proved easy to set up. I uploaded the reports at our on premises Report Server and users were able to access them. The only problem is that the data are embedded in the report(s), so to update the data one needs to open the actual report(s). This means that the update cannot be scheduled to happen automatically at offline hours which is particularly useful when a lot of data are involved. So I thought I should separate the data from the report(s) by taking advantage of the data source and dataset features of Report Server. I defined a data source of type XML pointing to our Project Server (connection string: "data source=https://xxx.xxx.com/sites/pwa/_api/ProjectData/Projects"). Pressing "Test Connection" reported back "ok" (although subsequent tests proved that almost any value entered there causes the same resonse). I then opened Report Builder and set as dataset the one I just created. Presumably because I specified an XML data source, I was presented with the text-based version of Report Builder where the user is expected to enter in the Query Designer window the actual query to be used. Does anybody know how to enter a valid query to read the XML data produced specifically by Project Server's ODATA interface? I assume it is some kind XML Query but I failed to find any examples or a simple tutorial. Furthermore, is this a good way to go about in order to create Project Server-based reports on an on premises Report Server (i.e. auto scheduled updates are very important) or should I employ some other approach? Thank you very much in advance.
XML Import Mobile Report Publisher Error
hi, I have a xml based dataaset that i want to use for mobile report. I could import the xml dataset in Mobile report Publisher but it doesn't show the correct data type. In xsd i have defined the field 'Salary' as Integer but in Mobile report publisher it is imported as Filter Field. Is it possible to change the data type direct in Mobile Report Publisher? <?xml version="1.0" encoding="utf-16"?> <xs:schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="data-set"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="record"> <xs:complexType> <xs:sequence> <xs:element name="Workgroup" type="xs:string" /> <xs:element name="Salary" type="xs:integer" /> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:schema> Thanks Neena
