Serverside Feasibility

To be honest, I am trying to shorten the curve, across the various data visualization tools.

So, rather than burn a week to bang out feasibility, I'd like to post it here.

1.) Have (Obviously) .Net MSSql Application on our dedicated server

2.) Sql Connect is local windows authentication

3.) Desire to choose tables/columns to form data visualization (NOT in a Desktop Program)

4.) Serve it into our admin pages

Current review, appears a data connection is doable, but serves to a Desktop Version of Power BI and back to Power BI Web Portal.

Preferred would be outside of our compiled code, but can include if necessary.