Migrate your Paginated reports to Power BI

Are your paginated reports still on-premises with either Power BI Report Server or SQL Server Reporting Services? Want to move them to Power BI? Patrick shows you how you can do that using the RDLMigration tool!

Documentation:

RDLMigration Tool on GitHub

GitHub release page

App Registration


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #Paginated #GuyInACube

[QuantumImperfections]

Your timing is impeccable. My organization is using a paginated push report service that I find largely abysmal. I've been eyeing PowerBI paginated Reports but the time sink to migrate everything was going to be too much. This. Is. Beautiful.

[DarkOrint]

Will it support shared datasources? Can you deploy to service from Visual studio? Also what about ssrs report solutions?

[ganeshpadvekar]

Great way to migrate the reports!! many thanks to Patrix & I have followed the same process & reports migrated successfully on service but the parameter of the reports are disabled. Please suggest.

[darahmireh]

Hi Patrick!!! This is an amazing app. I´m trying to do the same migration with Oracle and embebed that on a web app, do you know if that are already create by other developer? Thanks

[gamerleon]

Hi Patrick, is there a way to set a default date range to an in-between date slicer? For example when the user lands on the report, the date slicer should be selected for Last 30 days by default, then later they can change the date accordingly. Is there a video available on this topic, if no can you please make one?

Best Regards,
Pratik

[wwyokve]

Hi Patrick, could you please make a vedio about how to embed paginated report via Azure Portal? Thank you very much! I did successfully embedded PowerBI report via Azure before, but seems like the PowerBI report does not support using parameters in URL.

[ItsNotAboutTheCell]

Patrick: "Everyone's doing it... so why won't you?!" - LOL - that's the shirt.

[mattshrooms]

Hi Patrick,

Great video.
Would you know if this tool will migrate Subscriptions from SSRS reports deployed to SharePoint?

[wardadean]

Hey Patrick, thanks for the great vids! I need help. I need to move a bunch of paginated reports currently on a Power BI dev server, (in a file folder structure), over to the production Power BI Server keeping the same structure. Is there a way to do that?

[joefuller]

Hi Patrick,
will the folder structrure in SSRS be maintained?
I have different security on each folder will that also be maintained?

[akshaykhiste]

Are there any features which are not supported as paginated from SSRS ?

[puneethpenetrator]

HI Patrick,
RDL Migration converts SSRS report to paginated report in power bi ( which doesnt offer all features of power BI). Is there anyway we can convert SSRS report to Power BI report(not paginated report).

Power BI report designer tool will do the same thing which explained in video .

[nicolascuestaquintero]

Is there any approach to migrate all pbix files too (instead of rdl's)?

[RKTECH]

Hi Patrick, I am authentication issue to push reports to Power BI. How about if I just wanted to convert SSRS report and store locally or on network before I push it Power BI. any ideas?

[nganchi]

Thank you for your video. I have learned a lot from you. My SSRS report runs fine in the server. However, when I use RdlMigration tool, it was fail due to "Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'." How do I fix it? Can anyone has an idea? Thanks all

[eljangoolak]

Hi, great video. but you didn't talk about setting up the correct permissions in Azure Active Directory in order to be able to use the rdlTool. I registered the APP and got the App ID, but the option to change the APP to native is greyed out! so I use the default there. when I do that and run the rdlMigration code it tells me the app is not created by the AAD tenant and just gives me an error saying"Application with identifier 'XXXX' was not found in the directory 'YYY'. ". What can I do?

[SoumyaSamprathi]

Instead of Power BI Workspace can i directly upload the reports from SSRS to Power BI Report Server folder using RDLMigration tool?

[ncbshiva]

Can we use Data Driven Subscriptions in Power BI Service also, like that is present in Power BI Report Server ?

[yaseenabrahams]

Is it possible to migrate a Report to a new Tenant?

[angelfish]

Thanks for this - however, I notice this is just for premium licence users - we only have pro - is it available for pro users as well as we may think about migrating our SSRS reports in future. Also do you know if Data Driven Subscriptions are supported with PowerBI Paginated Reports?
Thanks