Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power BI Team,
I am trying to migrate or use SharepoiSQL Snt 2013 SSRS DB to PowerBI Report Server but getting an error below.
The database you have selected is configured for Reporting Services Sharepoint mode. Please select a SQL Server Database that is confugured for Reporting Services native mode.
Any thoughts?
Thanks,
GCE
In Power BI Desktop, in the ribbon, select Edit Queries, and then select Data source settings. Select Change Source, confirm your server and database names, and select OK. Close the data source settings window, and then select Apply changes.
Hello D-Gosbell,
I was able to successfully migrate using rs.exe script but the workspace can not be open after the migration. Any configuration, steps or permission needed?
Please advise.
Thanks,
GCE
As the error says, you cannot migrate a Sharepoint instance to a non-sharepoint instance. You will need to look at other scripting approaches (eg https://learn.microsoft.com/en-us/sql/reporting-services/tools/sample-reporting-services-rs-exe-scri... ) or manually re-deploy your reports to a new instance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |