topic Re: Power BI in ASP Net MVC in Developer

Power BI in ASP Net MVC

amassip — Fri, 16 Dec 2016 11:02:36 GMT

Hello,

I can display a RDL in an iframe from my own ReportServer and now I would like to display a report (ASP MVC application) without Azure.

On this link https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embedding-Basics

"but when using Power BI Embedded the tokens are issued by your own service and are specific to a report"

I understand that I don't need Azure but i need an accessToken to display the report...

Any idea ? Or Other way than PowerBI-JS ?

Thanks

Re: Power BI in ASP Net MVC

eyalc — Sun, 18 Dec 2016 12:28:48 GMT

Power BI Embedded can be used only as a resource in Azure (you can read on it here)

Re: Power BI in ASP Net MVC

Eric_Zhang — Mon, 19 Dec 2016 07:59:37 GMT

@amassip

I don't exactly understand what your mean "without azure". Both Power BI Service(at least Azure AD) or Power BI Embedded(Power BI workspace collection) are azure based.

Regarding getting an accessToken in Power BI Embedded, you can check DashboardController.cs in power-bi-embedded-integrate-report-into-web-app. You can explicitly specify when the token would expire, which means you can create a token never expires and use it anywhere in your javascript, though it is not recommended.

var embedToken = PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id, Convert.ToDateTime("2017-12-31"));

Re: Power BI in ASP Net MVC

amassip — Mon, 19 Dec 2016 13:20:39 GMT

@Eric_Zhang

I want to know if we can display a Power BI in a web app ( such as asp net ) but without Azure. I mean if there is a token that you acquired from the power BI authentification or something like that

But I think it is not possible, you have to intregate Azure in your project.

Re: Power BI in ASP Net MVC

Eric_Zhang — Mon, 19 Dec 2016 23:08:25 GMT

@amassip

Check if Publish to web from Power BI can meet your requirement. It is a public page and doesn't require any token.

Re: Power BI in ASP Net MVC

runrunrun — Tue, 20 Dec 2016 09:00:53 GMT

Hi,

you can check this out.You can get the clientID & clientSecret from registering your app here

I tried and it worked 🙂

Re: Power BI in ASP Net MVC

amassip — Tue, 20 Dec 2016 16:40:10 GMT

@Eric_Zhang

For privacy reason I can't publish report but thanks for the suggestion !

@runrunrun

Thanks, with your second link and from this link I can get the AccessToken 😉

I connect to my PowerBI account ( AuthorizationCode) then I get the AccessToken and finally I want to display my reports

But I got an error on this line :

using (var response = request.GetResponse() as System.Net.HttpWebResponse)

Error 403 Forbidden.

On the register application power BI page I choose only Read All Reports

//Configure Reports request
            System.Net.WebRequest request = System.Net.WebRequest.Create(
                String.Format("https://api.powerbi.com/beta/myorg//Reports", 
                baseUri)) as System.Net.HttpWebRequest;

            request.Method = "GET";
            request.ContentLength = 0;
            request.Headers.Add("Authorization", String.Format("Bearer {0}", accessToken));

            //Get Reports response from request.GetResponse()
            using (var response = request.GetResponse() as System.Net.HttpWebResponse) // here

EDIT : problem solve, thanks all !

Re: Power BI in ASP Net MVC

amassip — Wed, 21 Dec 2016 10:08:13 GMT

Hello

I have a last question :

https://app.powerbi.com/reportEmbed?reportId=21b8b191-9313-4ad6-8a33-xxxx ==> works well

Now I want to hide the filter panel :

https://app.powerbi.com/reportEmbed?reportId=21b8b191-9313-4ad6-8a33-xxx&filterPanelEnabled=false

==> nothing happened, in the internet explorer's console I can see 'access denied'

Filters' level : on the page

Re: Power BI in ASP Net MVC

runrunrun — Thu, 22 Dec 2016 01:20:37 GMT

AFAIK currently is not possible to hide filter panel or paging panel via REST API. Maybe we can upvote this :).

I tried using the same access token to embed report using powerbi.js, it didn't work. No console information, just blank screen

We can do it on powerbi.js though, see this link

Hope it helps

Re: Power BI in ASP Net MVC

amassip — Thu, 22 Dec 2016 08:12:03 GMT

@runrunrun

powerbi.js works, thanks 🙂

Re: Power BI in ASP Net MVC

Eric_Zhang — Thu, 22 Dec 2016 10:01:02 GMT

@amassip

PowerBI.js is awesome. However appending "&filterPaneEnabled=false" to a url still works when I test embeding with PowerBI REST API. It is just a little typo, try to drop the l in &filterPanelEnabled=false.

Re: Power BI in ASP Net MVC

silmar — Thu, 02 Feb 2017 21:15:01 GMT

Hi I am having the same issue, can get a token, but getting a 403 when I submit. What was your solution to get past the 403 in the Response?

Re: Power BI in ASP Net MVC

amassip — Mon, 06 Feb 2017 14:24:42 GMT

Hello

How do you get your token ? From the authorizationcode ( with your powerBI account ) ?

I used this code to get a report :

string baseUri = "https://api.powerbi.com/v1.0/myorg/reports";
string token =  "token";
//Configure Reports request
System.Net.WebRequest request = System.Net.WebRequest.Create(
String.Format("{0}",
baseUri)) as System.Net.HttpWebRequest;
request.Method = "GET";
request.ContentLength = 0;
request.Headers.Add("Authorization", String.Format("Bearer {0}", token));

using (var response = request.GetResponse() as System.Net.HttpWebResponse)
{
    //do something..
}

Given that there was the SSRS's update in January 2017, we can display powerBI in SSRS ( such as RDL ) but is it possible to take this url to display a powerBI report, i.e : in an iframe ? ( on-premise )

Re: Power BI in ASP Net MVC

daniels — Fri, 07 Apr 2017 23:03:42 GMT

Have someone try the filterpane=false and filter by report filters in SSRS 2016 on premise PowerBI reports?