Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Composite model visuals crash

Hello

 

I prepared a PBI desktop report, which contains two sources:

1. direct query to AAS

2. import from Azure SQL database

 

One of the calculated columns from the object managed via source 2. refers to the measure attached to the object from source 1. When I refresh the report locally on my desktop it works fine (all visuals are loaded correctly).

However, when I publish the report to the PBI service and try to refresh it, it seems to not work properly. After the refresh all the visuals return the following error message:

Do you have any idea how to solve this issue?

 

Thanks

Kamil

Need Help

5 Replies

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    4 years ago

    Hi Anonymous, 

     

    Is there a gateway for any of the data sources?

    Or maybe RLS set up for AAS?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi nickyvv 

       

      Not at all - no RLS, no on-prem data source. Pure cloud services.

      • aj1973's avatar
        aj1973
        Community Champion
        4 years ago

        Hi Anonymous 

        Is this checked in your desktop?

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    aj1973 For the second attempt, I switched on this option in my PBI dekstop and re-published the report to the cloud. Initially it was working, but when I started to select specific rekords in the visuals and filtering was applied, all of them crashed:

     

    • aj1973's avatar
      aj1973
      Community Champion
      4 years ago

      "See Details", what is it saying?

      the good news is that the report is connected to the surces and refreshing, however you should 

      Know that in DQ there are limitations, see if your report is falling into one of them here: