Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Custom Database in O365 SQL

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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.