Custom Database in O365 SQL

[Anonymous]

I am in need of building a custom SQL database in O365 for PowerBI to pull data and create visuals for. Understanding that these custom tables can also built in S/P and Excel, our organization needs to get away from manual inputs and changes to provide the latest, live, "as of" data. 

Plan - Create a front-end/layer interface for users to dump a standard data set/template, and the API connections with PowerBI can provide visual displays from the latest ingest. Is this possible? Where would I begin?

[Anonymous]

Hi @Anonymous ,

I'm not sure if i understand you correctly, but if you want to create table in Azure SQL, you may take a look at this documnet.

https://social.technet.microsoft.com/wiki/contents/articles/35932.creating-new-sql-database-and-table-on-azure.aspx 

Best Regards,

Jay

[PhilipTreacy]

Hi @Anonymous 

Perhaps you should look at Power Apps and Power Automate to get your data into a place that PBI can then be used to analyze it.

https://powerapps.microsoft.com/en-us/

Phil

[amitchandak]

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

[Anonymous]

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. 

[amitchandak]

@Anonymous , Are you able to connect to the SQL server in O365 using SQL server option in Power BI?

If so are you able to see the custom table?

[Anonymous]

As of now, i am not sure how to even create the custom table in SQL server. It's not letting me gain access like I normally would when a SQL db is spun up in the cloud environment outside of O365.