Composite model visuals crash

[Anonymous]

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

[Anonymous]

@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]

"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:

[nickyvv]

Hi @Anonymous, 

Is there a gateway for any of the data sources?

Or maybe RLS set up for AAS?

[Anonymous]

Hi @nickyvv 

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

[aj1973]

Hi @Anonymous 

Is this checked in your desktop?