Forum Discussion
Power BI Embedded questions
Hi,
We are working on a proof of concept with Power BI Embedded preview and we came across few questions. I have done research on internet regarding these questions but couldnt find much information.
1. Doest Power BI Embedded API Nuget Packages support MVC4 or is there a way to work with Power BI Embedded API in an MVC4 application because the provided GitHub sample and NuGet Packages target MVC5 but our applications are currently running on MVC4?
2. I want to pass a runtime parameter to the report developed by Power BI Desktop via my application. I want to pass a user Id GUID dynamically so that report is based on that user Id.
I have looked into filters but filters can be cleared by the end user. End user shouldn't be able to clear the filter/parameter.
I have looked into Parameters and I was able to add a parameter, set the value and get the results based on the parameter but the problem is how to pass that parameter through my MVC application. Is it using the querystring? Will the end user be able to clear this in his report?
3. In terms of accessing stored procs via advanced connectivity option under get data. It only supports Import option but no DirectQuery. My question is again passing parameter dynamically via application to this stored proc query, is there a way to do that?
Regards,
Adeel
14 Replies
As Microsoft describes, there are some limitations regarding the number of rows:
- 10,000 max rows per single POST rows request
- 1,000,000 rows added per hour per dataset
Let's for example say I have some tables with 1.500.000 or more rows inside. I am creating a dashboard on these tables (facts/dimensions) with some nice graphs using DirectQuery on an (azure) database (or can we use an on premise datasource with enterprise gateway??). I upload the pibx file to Power BI Service and integrate the dashboard into my cloud application (Power BI Embedded). Customers are checking the dashboards daily. How many rows are used within this queries when you show graphs with SUM functions? How can we check this? Maybe 70 customers with 10 users are going to use these dashboards in the future. This can be an issue when there are more then 1 million rows processed per hour.
Below link is a MVC sample foe embding Power BI:
https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-get-started-sample/
for passing filter from app you need to add the filter to the URL in format of {tableName/fieldName}:
https://app.powerbi.com/reportEmbed ?reportId=d2a0ea38-0694-4c70-9673-ee9655d54a4a&$filter={tableName/fieldName} eq '{fieldValue}'
Hi AliSharifi,
Thank you for the reply.
I have already tried that sample and it works fine but the question is related to the NuGet packages for Power BI Embedded which are currently not supported with MVC4 applications. Do we have to upgrade our applications to MVC5?
Regarding the parameter questions, I have read it on StackOverflow that end user would be able to clear that filter. We dont want end user to clear that filter, we are looking for some programatic parameter approach, is there any option available?
Regards,
Adeel
InsulaBIDev: Is Azure subscription mandantory for Power BI Embedded?
I don't have Azure subcription. Can i implement a poc like you with out the subcriptiion?
Yes Sunkari I believe you need an Azure subscription as you need to set up a Power BI Workspace Collection, and either a Azure SQL database or Azure SQL Datawarehouse (or HDInsights) - all done through the Azure Portal or using the API (which requires Azure credentials). I think you get one month of free credits when you sign up to Azure?
It is worth setting up a poc so that you understand the current limitations of of the Embedded beta offering so that you can track if and when these limitations are overcome and you can provide feedback to the team. My experience with the Power BI team so far is that they will move quickly to fill in the gaps.
I followed the steps here:
https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-get-started/
Hello,
I have one power Bi report which i have loaded in my .net web application using embed-a-report-into-an-app.
In this report i have used web api to get data. I have to pass LOGIN USER ID AND COMPANY ID from web application to power bi for create dynamic web api url.Any body have idea on that?
Thanks in Advance.
