Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
As an organisation, we're currently looking at updating our core business application which will in turn provide opportunities to upgrade our reporting infrastructure.
Presently, we've rolled out PowerBI and have made several reports and dashboards available to end users. We still however have our legacy Reporting Server site which houses 2-300+ .rdl files built against 2008 R2.
When our business application is upgraded, we will be moving our reporting from an on-premise SQL Server hosted in Azure to an Azure Data Factory (PaaS) to service our reporting. In the interim, we will still need access to the legacy reports whilst we decide what to migrate to our PowerBI model and what can be discarded.
Realistically, how feasible would it be to migrate our reports from Report Server to the PBI Service?
My current thinking is that we would do the below in PowerShell but I'm not 100% all of it would be feasible; has anyone else got a similar experience or any advice on this?
Unfortunately, the business need is that we keep these older reports which will naturally be less efficient but the plan will be to whittle away any that aren't relevant pre-migration. I want to have this process as automated as possible, namely in that I don't want to be manually dragging 2-300 files across myself!
Also, if we suddenly dump these files to the PBI server, will this also have an impact on our premium capacity usage? My gut feeling is that it will and may mean we need to upgrade (currently on P1).
Any thoughts? Any similar experiences?
Solved! Go to Solution.
Hi BM4291,
I sent you a private message to better understand the scenario. To the last part of the question on if this would affect your premium capacity usage; you can choose the amount of memory used by the paginated reports workload, so if you don't expect a lot of concurrent usage you can set that at a lower value. But it will use/share the resources with the other workloads.
thanks
-Boreki
Hi BM4291,
I sent you a private message to better understand the scenario. To the last part of the question on if this would affect your premium capacity usage; you can choose the amount of memory used by the paginated reports workload, so if you don't expect a lot of concurrent usage you can set that at a lower value. But it will use/share the resources with the other workloads.
thanks
-Boreki
hi,
Migrating reports from Report Server to PBI Service is certainly possible. We have plans to provide a migration tool to do this but it is not ready yet.
Uploading all reports to single workspace bound to premium capacity should not overload the capacity. Resource usage is primarily a function of render request frequency and complexity. Please note that if your capacity is from before May 2019 then you will need to manually enable Paginated Reports workload through Power BI's Admin portal.
Thanks,
Rohit
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |