Scan Excel/PowerPoint Data sources
Hi, Let's imagine that Excel uses a database or Power BI as a data source (i.e. for a Pivot Table), will Purview scan the Excel file and visualize the lineage so that you can track which Excel document is using which Power BI data set? I know it's possible with Power BI reports to find out which Dataset they are using, but it would be super helpful to find out what data sources the world's most popular BI front-end (Excel) is using 😉 Same with PowerPoint. So you can embed a Power BI report into a PowerPoint document. Will Purview scan the PowerPoint documents and find out which report/visual they use? For Impact Analysis (I would like to change a report, what other components will be affected) this would be very important... Thanks, Thomas
Changing location of backend database without redoing the frontend app
Hi. I have a database that I have split into backend and frontend. The splitting occurred in our local server, so the backend is naturally stored there. Naturally, this is also the path that is associated to the frontend such that if I move the backend to a different location, the frontend will no longer be able to access this database. Unfortunately, this is my conundrum. I need to transfer the backend file to the cloud since the server is prone to connectivity issues. I've had multiple instances of data corruption due to service interruptions and the cloud would save me from this problem. But, if I simply transfer the backend file, the frontend will be rendered useless. I can relink the tables and other whatnots but that would mean I have to re-position all of my fields in my UI, not to mention modify the VBA codes as needed. Is there a way for me to execute the transfer without having to redo the frontend (the fields, codes, etc.) from top to bottom? Thank you.
Dataview Date Sources Missing
Noticed an issue with SP Designer and dataviews within classic pages on 04/27/2020 after the MS removal of the ability to create custom list forms via SPDesigner. Now when editing any classic SharePoint page within SPDesigner that has a dataview on it, the dataview gets its data source ripped out and if page is saved now the dataview will no longer work. You can manually add the datasource back into the dataview but if you come back to the page in SPDesigner it is missing again. See screenshot below of where the datasource is removed when viewing on the page. Have confirmed this behavior on multiple tenants with various admin user accounts. Tried the usual clearing of cache and such to confirm not a local issue as well. Seems to possibly be related to the recent SPO update to remove SharePoint Designer's ability to create custom forms in your environment.
Connecting Excel to SQL Error
I am trying to connect Excel to my 2005 SQL Server. When I enter my credentials, I get an error stating "We couldn't authenticate with the credentials provided. Please try again." I know that my login credentials are correct because that is what I use to login to the SQL Server. Do I need to set up a new ODBC connection? Any and all advice is greatly appreciated.
