Forum Discussion
Custom Database in O365 SQL
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Also refer : https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/enable-usage-analytics?view=o365-worldwide
Appreciate your Kudos.
Hello...ok...
1) We are able to access the SQL server DB in our O365 account.
2) I have custom built tables that is based off of our internal template for a financial report
3) I want our PBI to pull data directly from that "custom table" from our SQL server
4) If all that is complete, I plan to build a custom front-end interface that will allow users to upload their data set into the SQL DB so that PBI can visualize and provide reports.
The reason why our organization is looking to build custom tables in SQL vs using excel or S/P is because with the amount of changes of the data template. I am just trying to figure out how to access the back-end of O365's SQL DB to do some custom development, and/or if it's even possible.