cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kamilzet__
Frequent Visitor

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:

kamilzet___0-1632319410314.png

Do you have any idea how to solve this issue?

 

Thanks

Kamil

5 REPLIES 5
kamilzet__
Frequent Visitor

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

kamilzet___0-1632324777502.png

 

aj1973
Community Champion
Community Champion

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

aj1973_0-1632331293074.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

nickyvv
Community Champion
Community Champion

Hi @kamilzet__

 

Is there a gateway for any of the data sources?

Or maybe RLS set up for AAS?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Hi @nickyvv 

 

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

aj1973
Community Champion
Community Champion

Hi @kamilzet__ 

Is this checked in your desktop?

aj1973_0-1632324208360.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors