Forum Discussion

kevinfranck's avatar
kevinfranck
Frequent Visitor
5 years ago

Report Could Not Access the Data Source - Warning (SSAS Data Source)

We have recently been experiencing an intermittent error with a report in one of our PBI Workspaces.  The error is the standard:  "This Report couldn't access the data source. Contact the author to h...
Need Help
GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi kevinfranck 

 

What does it say when you click on See Details?


it would appear to me that there is some change made to the SSAS server, and due to the reprocessing it fixes the issue?

  • kevinfranck's avatar
    kevinfranck
    Frequent Visitor
    5 years ago

    Thanks for the reply.  There is new data that is added every couple of days to the Tabular Cube but the structure of the cube is not changed.  Most recently the FULL reprocessing of the Tabular Cube is not fully resolving the PBI Reports that are built off of the dataset.  This morning when I opened one of the reports which has a page for each of the top customers i received the same error message as shown in the initial post.  That resolved the all of the pages in the report except two of them.  I then put the report in EDIT mode, selected the Refresh action and the data was pulled in for that page as well as the other page that displayed "Can't display the visual. See Details" message.  Could this have anything to do with available capacity?  We have the A1 Node for Power BI Embedded.

    • christielu's avatar
      christielu
      Frequent Visitor
      4 years ago

      Hi Kevin , did you end up finding a solution? We are having the issue and it's been on and off for a few months now. Restarting our SSAS server works, although sometimes we need to reboot a few times. Thanks!