Embed report error

[DavideBono97]

I have a report that if I open normally from app.powerbi.com everything works

If I embed the report I get this error

Errore sottostante: PowerBI service client received error HTTP response. HttpStatus: 503. PowerBIErrorCode: OpenConnectionError
OpenConnectionError: Failed to open the MSOLAP connection.
ID di correlazione: b25800ca-de51-48a1-ab6d-0d5d260cd415
ID attività: 86ea0a8c-08b1-41f4-aaa0-c157f8829c5b
ID richiesta: ebaec16b-3149-410d-997b-1c4af0e696d4
Ora: Tue Dec 13 2022 08:52:49 GMT+0100 (Ora standard dell’Europa centrale)
Versione del servizio: 13.0.19585.64
Versione client: 2211.4.11379-train
URI cluster: https://WABI-NORTH-EUROPE-redirect.analysis.windows.net
ID attività: 86ea0a8c-08b1-41f4-aaa0-c157f8829c5b
ID richiesta: ebaec16b-3149-410d-997b-1c4af0e696d4
Ora: Tue Dec 13 2022 08:52:49 GMT+0100 (Ora standard dell’Europa centrale)
Versione del servizio: 13.0.19585.64
Versione client: 2211.4.11379-train
URI cluster: https://WABI-NORTH-EUROPE-redirect.analysis.windows.net

What can I check ?

Thanks in advance

[ibarrau]

Hi. Can you share more details? for example, what is your data source? how are you embedding? (there are 3  or 4 different methods)

The only thing I can check with the error is that it's using MSOLAP driver that it's usually used for Microsoft Tabular models. I can assume an issue with analysis services or different things.

Regards,

[DavideBono97]

the data source is a sql server database
On powerbi.com the dataset is set correctly as show 

the report I'm trying to embed is in one workspace while the dataset is in another workspace

to create the embedtoken I use this piece of code :

var tokenRequest = new GenerateTokenRequestV2(reports: new List<GenerateTokenRequestV2Report>() { new GenerateTokenRequestV2Report(report.Item1) },
datasets: v2DatasetID.Select(datasetId => new GenerateTokenRequestV2Dataset(datasetId.ToString())).ToList(),
identities: v2rls,
targetWorkspaces: v2WsID
);

// Generate Embed token
var getToken = client.EmbedToken.GenerateToken(tokenRequest);

My config client side is : 

var config = {
                    type: pbiType,
                    tokenType: pbiModels.TokenType.Embed,
                    //theme: { themeJson: getCurrentTheme() },
                    accessToken: options.TOKEN,
                    datasetBinding: {
                        datasetId: options.DATASETID,
                    },
                    embedUrl: options.EMBEDURL,
                    id: options.IDREPORT,
                    layoutType: models.LayoutType.Custom,
                    customLayout: {
                        displayOption: models.DisplayOption.FitToPage
                    },
                    permissions: pbiModels.Permissions.All,
                    viewMode: pbiModels.ViewMode.View,
                    settings: { 
                        panes: {
                            filters: {
                                visible: false
                            },
                            pageNavigation: {
                                visible: false
                            }
                        }
                    },
                };