I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to create several reports and tableau dashboards.
In Visio, you have the option to create an organizational chart via a Wizard and "an ODBC-compliant data source". After clicking on our Smartsheets connector, I can select the correct sheet. Yet, visio is unable to "read names from ODBC data source". Can anyone assist?
I also received this error in Visio when connecting to the sheet in Smartsheet through the ODBC connector, however, when I created a report from the original sheet that only included Employee name, Reports to, Title and Location and used that as the database table then the Visio Organization Wizard was able to process the request. The error may have something to do with connecting directly to the sheet and/or parsing through additional columns.
Is there a way to allow users who have edit rights to a page in WorkApps to create custom filters and export the sheet to MS Excel? These features are available if you give someone edit permissions directly to the sheet but not when assigning permissions via WorkApps.
I am trying to drag and drop an email from Outlook in Office 365 to row in my sheet. I can't get it to work. But, when I go to my desktop Outlook and drag and drop it, I have no problem. Does anyone know why this is and is there a work around? Thanks! Rebecca
@Penrynian I'm seeing the same issue very frequently at the moment, whereas it would be rare usually. My more common issue used to be the Visio file becoming read-only. I'm hoping that if enough people report this, then perhaps we have evidence for Microsoft to take action.
@ParryFen, @Penrynian , I'm just chiming in with a me too as well from Australia. in my instance my account has a visio plan 2 license. also cropped up incidentally around the end of last year, but I only realised it's a persistent issue today. things I've excluded/looked at in my testing:
@armen-iptel, I've had this same problem on and off since I started using Visio Plan 2, currently v2101. I access files through Sharepoint with a local sync to File Explorer. I had the error opening the local copy. I also logged into O365 and opened it in the browser and then chose to open the file with the desktop app from there. Same error. I closed Visio and clicked "free up space" on the context menu in file explorer to delete the local copy. Then I double clicked the cloud copy which opened in the desktop app and, this time, no error.
Hi, I have a bit of an odd issue that I've put up with now for several months. First off I'm using visio plan 2 so is latest version. What happens is when I try to open the file menu for the first time for a newly opened document visio will hang for nearly 20 seconds. But then after that it's fine, can open file no problem. It only happens the first time.
For example, I'll open my template doc and start working (add pics, text, lines, etc). Periodically save the doc. Then when I click file to export as pdf it will hang for ages. Doesn't crash or cause a problem, just hangs for at least 20 seconds. Once File menu opens everything is fine. Can export, etc. And then if i change something on the doc and go to file again there's no hanging. If I close the doc and open again it will hang the same way for the first time opening file. So it is literally just the first time use of the file menu.
I've tried all the options suggested on-line (repair, changing settings etc) and none worked. Then it occurred to me that my default printer was networked (I don't have any printers directly connected to my main workstation) - so I changed my default printer to "Microsoft Print to PDF" in the Settings app. The problem went away.
I have finally managed to get everything workgin now. I saved the Power BI file (.pbix) on my desktop and uploaded it to Power BI Online. I added the embeded URL to the Visio Visual in Power BI Online and the visio diagram is now working.
Step1. Update Power BI Desktop to the latest version.
Step2. Use your dataset and .vsdx file to try again, if visual is still blank, please use the sample data set and .vsdx file to try again.
Step3. If the sample data file still can not be displayed, it may be a problem with your operation or other problems. If the sample file can be displayed normally, then your dataset and .vsdx file may not meet the visual's requirements.
This visual was working the last few months and since last friday, it shows a "Sorry, we ran into a problem error". This however works/displays in the BI workpsace and app after publishing. So unsure why it juts stopped displaying in desktop.
I also have a unique ID on my data set in Power BI. Next, I clicked on the "Visio Visual", and copied/pasted the Embed URL from my visio in One Drive into the text box on the Visio Visual Diagram and clicked "Connect" and it is still displaying a blank diagram.
Hi @Anonymous - did you ever manage to get this working in PBI Desktop?
I came across this thread as I have exactly the same issue; my Visio visual does not appear in desktop (nor does the demo visio file). In both cases the Visio visual does appear in PBI Online when I enter the embed URL but that doesn't help as I still need to build and configure the report in desktop.
Any help appreciated!
The only rear facing images were actually pictures from product marketing. Your SE should be able to request those images or find them in the internal product marketing powerpoints. But they won't be visio stencils.
How are you exporting/importing? Using the Export dialog and then selecting Visio (XML)? Since it is XML, you could open the exported file in a text editor and read through it searching for one of your text boxes and see if the attributes are correct (location, alignment, etc).
I finally gave up - Making sure drop shadow was off, that the font you have is the same as available on PC side, Using office 365 version of Visio and not 2016 visio - these helped a little, but eventually it got to the point where I just used a 30 day free office 365 trial on mac using parallels
Various elements of the picture have stood out to me at different times depending on what is happening in my life at that moment. There are times when I connect with Jesus reaching out his hand to help someone. More times than not though, I connect with the little girl accepting the hand of Jesus to save her or the toddler in his arms in need of much comfort and care. Sometime it is the raging water or the rugged terrain that captures my attention.
Contemplative prayer often brings us to an intimate encounter with the love of God, revealed to us in Jesus. In such an experience we come to know ever more deeply that God is not against us, but for us; not far from us, but with us; not outside of us, but deeply within.
As we take a quiet moment to reflect in a peaceful place, our minds and hearts become still and, in this stillness, become deeper and wider, inviting/unbinding the eternal quality of life in all its fullness. It is in the growing inner awareness of the eternal embrace of God that we find our true freedom.
Visio Divina, sacred seeing, is an ancient form of prayer that continues to be a powerful method of meditation. Art becomes the sacrament that opens our hearts to the indwelling Spirit of God. The visible makes the invisible present in a palpable way.
Any piece of art can be the subject of reflection. It is not necessary for it to be religious art; however, reflecting on icons has been practiced since ancient times. The steps of Visio Divina are similar to those of Lectio Divina, which I wrote about last week.
Identify the art that will be the subject of your reflection. Then pick a comfortable place where you will not be disturbed or distracted. Relax. Closing your eyes and focusing on your breath can be a helpful way to center yourself in the divine.
Gaze at the entire picture. Notice the shapes, the colors, and the lighting. Notice the detail of both the foreground and background. Once you have visually canvased the artwork, note what has drawn your attention. Just like in Lectio Divina, it is God that is luring you to a treasure meant just for you.
Visio Divina sets our interior stage for a soulful connection with our Maker where intimate communion is possible. I have discovered that Visio Divina encourages the practice of viewing all of life through a sacred lens uncovering the messages hidden within creation. All of life then becomes hallowed ground.
By Fr. Ron Will, CPPS
I hope that my reflections make you more attentive to the Eucharistic Prayer at the next Mass you attend. When you really listen to the readings and the prayers, the pieces of the puzzle of the Mass come together and you see the incredible vision God has for us.