Problem with composite model - "Couldn't load the data for this visual"

[Camille_G]

Hello Power BI community, 
I have a problem with a report since this morning, which was not present before.
The report is based on a composite model that contains Import data + Direct Query data from 2 different Power BI models.

The tables from different sources are linked together in the data model, and it seems the problem only comes when some tables are put together in the same visual.

And the strangest part is : it works locally in Power BI Desktop !

It used to work properly without a problem, but now it shows the following error in the service : (excuse my French !)

ID d'activité: 86df062e-c596-459a-8c19-264f58f0e788

ID de demande: 8a6b63b2-6bb9-4684-8ba1-cbe18affba00

ID de corrélation: 8b8a0613-fa2d-4017-95c0-a6d2217af815

Heure: Mon Oct 16 2023 14:53:59 GMT+0200 (heure d’été d’Europe centrale)

Version du service: 13.0.21891.45

Version du client: 2310.4.16252-train

URI du cluster: https://df-msit-scus-redirect.analysis.windows.net/

Can anyone help on this issue ?

[aj1973]

Hi @Camille_G 

Refresh the report in your destop and Try to republish again to see what happens ! Latest updates in Power bi could be the cause. 

[Camille_G]

Hi @aj1973 , thank you for your reply !
We tried this but it didn't work.
However, since then it seems to have fixed itself overnight...
This is a bit frustrating because we have absolutely no explanation in the end.
Maybe it was some kind of update, but there was no announcement of any kind...

[aj1973 · Accepted solution]

Indeed, every month there are new updates in Power BI and you need to be up to date. Example there was major updates on Power BI Gateway lately and it was a must to update it 

You can subscribe for the latest updates here

https://powerbi.microsoft.com/en-us/blog/