Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I was planning to migrate from SSRS to PowerBI. I have about 5000 reports with only 4 shared datasets. I have read that using the RDL Migration Tool, shared datasets are converted in embedded datasets:
Is there an automatic way to change the embedded dataset with a shared dataset available in PowerBI Service?
If it's not possible, which other options can I evaluate? I think it's impossible to manage 5000 reports with embedded dataset.
Regards,
Leonardo
The RDL's are XML. The way I'd approach this is to build and RDL on the service with an embedded set you are trying to use. Download the RDL and notice the dataset XML node generated by the service. Once you have the pattern you can script generating the node(s) in all the RDL's you are looking to modify.
regards,
Luis H.