Forum Discussion

DaveCope's avatar
DaveCope
Frequent Visitor
7 years ago

D365 Open Connection Error on all visuals

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...

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      DaveCope
      Frequent Visitor
      7 years ago

      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