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 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?

Need Help

6 Replies

    • 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?