Visio professional, link data from visio to sql server

butter flies 1 Reputation point
2023-01-05T14:09:55.16+00:00

Hello ,
I have created a standard diagram from a blank diagram using only containers and database shapes. I did a custom import from SQL Server to pull data through a view and I linked the rows to have the latest data. When I do a refresh I get many wrong things happening. first the conflict window appearing , my database shapes that I have place are mixed up within other containers and I lost some of my links. Please advise on these issues.

Visio
Visio
A family of Microsoft products used to create diagrams and vector graphics.
77 questions
Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
247 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2023-01-06T05:45:00.477+00:00

    Hi

    Please check whether the articles 'Use the Data Connection Wizard to import data into Visio' and 'Import data from Excel, Access, SharePoint sites, SQL Server, and other external sources' are helpful to you.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. butter flies 1 Reputation point
    2023-01-06T14:25:47.627+00:00

    Hi,
    I looked at the link you provided for linking the data to a shape and I did do those steps. Unfortunately, the links are getting dropped when I do a refresh. Also , the shapes that I had organized in different containers are now all mixed up.