Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Questions on moving SSRS reports to Power BI Service.

 

Greetings. I've done some googling on the topic of moving SSRS reports to Power BI Service and want to clarify a few things:

 

  1. Premium is needed, Pro won't cut it?
  2. According to this acrticle, I should be able just to download an .rdl file from SSRS, then upload right to Power BI Service?
  3. The article doesn't account for Data Sources, Subscripions, etc. but I'm assuming I can recreate those and hook my reports in to them?
  4. In Power BI Report Builder I don't have all the options shown at the top for eidting a Workspace -- is that because I don't have Premium?

Thanks!

  • GilbertQ's avatar
    GilbertQ
    6 years ago
    Hi there

    You will have to open the RDL file, run it and see if it works in Power BI Report Builder.

    If it does you can then upload it to your Power BI Premium App Workspace and test.

4 Replies

  • Hi there

    Here are the answers below

    1. Yes currently you need Power BI Premium
    2. You will have to create the report using Power BI Report Builder and then upload that new RDL.
    3. Not all data sources are supported currently in paginated reports. As well as data driven subscriptions are not working, but normal scheduled subscriptions are.
    4. Power BI Report builder is the authoring tool and does not have workspace options?
    • Anonymous's avatar
      Anonymous
      Not applicable

       

      2) So one cannot take an .rdl from SSRS and upload it? The .rdl MUST be created in Power BI Report Builder?

      4) No, I seem to be missing a lot. FYI this is the first time I've ever even opened these tools, so I could be missing something glaring. 

       

      Thanks!

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        Hi there

        You will have to open the RDL file, run it and see if it works in Power BI Report Builder.

        If it does you can then upload it to your Power BI Premium App Workspace and test.