Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
  • 1.  Report Builder

    Posted 13 days ago

    I'm running into a roadblock in the attempt to start converting all our SSRS reports to Power BI. For the record, we are running an on-prem version.

    Are there any settings within Power BI that grant permission to run reports through Report Builder?

    Here's the situation. 

    What we've done so far is install Report Builder for myself and our data analyst.  We then uploaded a .rdl file from one of her SSRS reports.  That all looks fine and as it should.  We can set up the connection to the db and test it and we are successful.  When either of us try to run that report, we get errors that say we have insufficient permissions. 

     When running the report from the dashboard.

    • An error has occurred during report processing. (rsProcessingAborted)
      • Cannot impersonate user for data source 'ADR_Live'. (rsErrorImpersonatingUser)
        • Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
          • For more information about this error navigate to the report server on the local server machine, or enable remote errors

     When running the report while in Report Builder.

    Report Builder Error
    Any help is greatly appreciated.


    ------------------------------
    Larry Dreifke
    Manager - User Experience
    Milwaukee WI
    ------------------------------