Deploying SSRS report to PowerBI Server
Hi, I am looking to deploy an SSRS report in PowerBI Report Server. I succefully uploaded a report.rdl file to PowerBI report Server. I can see the structure of the report as the report runs of two paramaters that the user needs to key in/select and then click viewreport as in the following screenshot. I get the following error: "The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)" I then went on to change the credentials(credentials which works fine on regular powerBI reports I developed) in manage datasource, I get the follwoing error: "An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'MarketsAnalytics_Team'. (rsErrorImpersonatingUser) Log on failed. Ensure the user name and password are correct. (rsLogonFailed) For more information about this error navigate to the report server on the local server machine, or enable remote errors" is this something of a configuration issue in PowerBi Report Server or SQL Server Report Server(2016)? Thanks
Migrate from SSRS 2016 to Power BI Report Server
I recently tried to migrate from SSRS 2016 to Power BI Report Server (March 2018). I ran into an issue where the database would not upgrade. I tried pointing the PBIRS configuration to the existing report server database and I also tried restoring the ReportServer database over a new database that was configured by PBIRS and neither worked. What is the correct way to perform the migration? Microsoft's documentation is very vague on this and I could not get it to work.
Power BI Report Server & SSRS - Do they share any configuration / settings?
I have Power BI Report Server configured on a server & everything was working fine. I then installed SSRS 2016 & all was well except for the two issues below. https://social.technet.microsoft.com/Forums/projectserver/en-US/27805056-f951-4b93-a9e3-91a0fb3fc424/ssrs-2016-web-portal-hidden-reports?forum=sqlreportingservices Having trouble adding users from a different domain forest to SSRS IMPORTANT NOTE: At this point, Power BI Report Server was not experiencing issue 2. Users in both domain forests were being added with out any problem. In trying to resolve issue 1 for SSRS, i installed SQLServer 2016 SP2 and indeed that resolved issue 1 for SSRS. PROBLEM: Updating SQLServer 2016 to SP2 now introduced issue 2 to Power BI Report Server. Now in Power BI Report Server, users in "DomanA" can no longer be added. Trying to add them now throws the error "The user or group name "DomainA\username" is not recognized" So, does any one have any idea why updating SSRS instance to SP2 could end up affecting the BI Report Server configuration. Are there any configurations being shared between the two products?
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
