Serverside Feasibility

[inspetta]

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.

[v-yuezhe-msft]

Hi @inspetta,

Based on your description, you want to integrate reports into your application, right?

If that is the case, you can firstly create reports in Power BI Desktop, then use Power BI embedded feature to integrate Power BI reports right into your web applications, for more details, please review this article: https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-what-is-power-bi-embedded .

Moreover, another option is to create reports in Power BI Service,  then you can integrate reports into web app using Power BI API, some JavaScript code and an IFrame. For more details, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report/ .

You can also review the following article about what developers can do with Power BI.

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-overview-of-power-bi-rest-api/
 

Thanks,
Lydia Zhang

[inspetta]

Thank you for the suggestions.

Your comment "Moreover, another option is to create reports in Power BI Service,  then you can integrate reports into web app using Power BI API, some JavaScript code and an IFrame. For more details, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report/ ."

..Sounds like what I am looking for.

Let me read this and figure out how to get it in place.

Is there a service, if needed, that I could pay to guide me... not to do it, but to guide me?

Thanks!

[v-yuezhe-msft]

Hi @inspetta,

I am afraid that there is no such service. The above official article is a step-by-step tutorial, you can also get example code from the following links.

https://github.com/Azure-Samples/power-bi-embedded-integrate-report-into-web-app
https://github.com/Microsoft/PowerBI-CSharp/tree/master/samples/webforms/embed-a-report-into-an-app

If you have any questions about intergrating report to application using Power BI API, you can post the question in Power BI Developer forum at http://community.powerbi.com/t5/Developer/bd-p/Developer to get dedicated support.



Thanks,
Lydia Zhang

[inspetta]

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.