Forum Discussion

Maverik91's avatar
Maverik91
Icon for Helper II rankHelper II
1 year ago

How to Reuse Credentials Across Multiple Reports in Power BI Report Server

Hi everyone,

I am trying to understand if it is possible to reuse the same credentials across multiple reports in Power BI Report Server.
My goal is to:

  • Set up credentials once for a data source and use them across different reports.
  • Avoid having to configure separate credentials for each individual report.

Is there any official documentation or a link that explains whether this is possible or not?

I need to provide my client with documentation about this feature.

Thank you in advance for your help!



 

Data Source Configuration
Power BI Report Server

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,Maverik91 .I am glad to help you.
    You may be able to use the powershell command to accomplish your needs
    URL:
    powershell - Set report data source and credentials on Power BI Report Server through REST API to establish a scheduled refresh - Stack Overflow

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


    • Maverik91's avatar
      Maverik91
      Icon for Helper II rankHelper II
      1 year ago

      Hi Anonymous ,
      although this answer gives very good hints for a possible management by the it group, what we want to achieve must be feasible by any user maybe without knowledge of powershell or various api.
      so I can't accept this solution because it doesn't cover the required needs.

      thanks anyway

  • Maverik91's avatar
    Maverik91
    Icon for Helper II rankHelper II
    1 year ago

    Hi Anonymous ,
    although this answer gives very good hints for a possible management by the it group, what we want to achieve must be feasible by any user maybe without knowledge of powershell or various api.
    so I can't accept this solution because it doesn't cover the required needs.

    thanks anyway

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi,Maverik91 .Thank you for your reply.
      If you don't have access to Powershell/other APIs for unified processing of reports, then there may be no other shortcut to solve your problem for now.
      I would prefer to centralize and unify the management of pbix reports that use the same credentials for authentication. Save them to the same folder. In the future, you can manage better when you change the data source credentials of the reports.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    HI Maverik91 ,

    Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

    Otherwise, feel free to reach out for further assistance.

    Thank you.