Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Publishing Pagianted Reports Unable To Access Report

I am one of two people publishing pagainted reports to premium workspaces, I can publish the reports and users can access with no issues, while the other person who is also an admin of the workspace who publishes a report, people can't access the reports unless I "take over" the datasource. There are one or two workspaces that they are able to publish reports to without issues but all workspaces are configured the same way, and all reports are pointing to the same azure SQL database.

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

    Any security setting on your data source side? If this is a case, it may be caused other users can't use their credentials to access resources except you 'take owner' of that data source to share your credentials.

    In addition, what type of datasoruce are you worked? Azure SQL or Azure AS? if you mean Azure AS with live connection mode, you can also take a look at the following blog about UPN settings:

    Manage your data source - Analysis Services 
    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Anonymous 

       

      No both of us have the same DBO  permissions to the Azure SQL Database. 

       

      we are configuring the reports to use windows authentication, kerbos delegation may be required. Does this mean when we are publishing reports, they are using the credentials of whoever published the report and not their own credentials? We are wanting people to be accessing the data as themselves, not an impersonated connection. Can you confirm how this is supposed to work?

       

      thanks,

      Sam

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Additionally this is what the datasources show when I look at them in power bi service, i just leave it blank don't change anything and users are able to access reports

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous 

         

        I did some experimenting and found out that the reports are using a SQL authentication when I publish them, even though when building the datasource in paginated builder, i've choosen windows. Any idea how I can change that default authentication? I'm not using a gateway and i hadn't been changing the connection once published:

        Data Source={intentionally_removed}.database.windows.net;Initial Catalog={intentionally_removed};Encrypt=True;TrustServerCertificate=False

        for credentials I have the radio button selected for "Use Current Windows User. Kerbos Delegation May Be Needed"