D365 Open Connection Error on all visuals

[DaveCope]

Has anyone seen this error message before and knows what it means?

We have modifed a standard analytical workspace and when we attempt to re-embed all visuals return an error saying "couldnt load the data for this visual" with the following technical details...

[v-yuezhe-msft]

@DaveCope,

What specific D365 content pack do you connect to in Power BI Service? What is the result if you refresh the dataset in Power BI Service?

Regards,
Lydia

[DaveCope]

This is for an extension of the Cost Accoutning Anylsius reporting that uses the CAMAggregatedEntity

We have not previously had to uplaod the reports to PowerBI service, this client wishes to utilise the licencing they get as part of the their D365 F&O subscipriotns and so we are embedding the reports back into D365 via visual studio as we have done previosuly for other clients

The only difference in this instance is that this clients environments are on an elastic pool. Previously when we have embedded a Power BI report back into an environment I have set the server & database address to .;AxDW and everything has worked fine. I am wondering if I need to use a different address for the local entity store in this case given the elastic pool setup?

The entity store has been refreshed and all standard analytical workspaces are running as normal

Appreciate the help

Dave