Forum Discussion

mtran1210's avatar
mtran1210
Regular Visitor
3 years ago

This report couldn't access the data source. Contact the author to have it fixed.

I have a few users that are getting this error "This report couldn't access the data source. Contact the author to have it fixed."

 

We are using an SSAS Tabular Data Model and have Azure AD Groups set up for access. 

 

I have already tried troubleshooting below: 

  • Giving user direct access to data set - Failed
  • Downloaded and republished report to workspace - Failed
  • ReAdded user to active group - Failed
  • Recreated role in visual studio and redeployed model - Failed

Is there anything else I can look into or try?

Need Help

5 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    3 years ago

    HI mtran1210 ,

     

    I am wondering if the users in particular are in the App Audience?  I assume they are but am checking.  

     

    Do the users with the issue have a license to Power BI?

     

    If this works for some users and not others I would tend to lean towards a permissions problem - what is the difference in the APP permissions between the users?  AND/OR what is the difference in the workspace (or maybe even the report itself?) permissions?  

     

    Is the data source a custom one or has some permissions in it that is using named users and not a service account and therefore the users are not in the data source?

    • mtran1210's avatar
      mtran1210
      Regular Visitor
      3 years ago

      Hello collinq , 

       

      1. The AD group that the user is added to are in the App audience. 

      2. They have PowerBI Pro licenses. 

      3. In the workspace, the AD group that they are in has the Workspace Viewer permission. 

      4. We do have a Tabular Model Security layer which has that AD group added as well. 

       

      • collinq's avatar
        collinq
        Icon for Super User rankSuper User
        3 years ago

        Hey mtran1210 ,

         

        How about the Data Source and/or the Gateway?  is the DataSource set up and working?  And, the Gateway is fine as well?

  • mKarthikeyan's avatar
    mKarthikeyan
    New Member
    2 years ago

    This report couldn't access the data source. Contact xxx, the author, to have it fixed.

    All the reports which have been created on tabular model and working previously are not working now. We have checked Gateways, Connection. Those works as expected. By Show the above error while opening the report.