Power BI Clarifications - Q&A

  
1.       How can we display Power Bi Visuals inside SharePoint
a.       Can we display the whole Dashboard inside SharePoint Pages
b.       Or can we display just one Visual inside a SharePoint Page using an App?

Response : A new feature has been added to PowerBI.com which is managing of embedded codes in the Settings section of PowerBI. It was added sometime last week only.
3rd party is available at $3 per month: https://store.office.com/power-bi-tiles-for-sharepoint-WA104379750.aspx?assetid=WA104379750&sourcecorrid=bd27d848-b8e6-4da0-a848-e81d193dd317&searchapppos=2
Also, you can embed Power BI Tiles into Office Documents: https://store.office.com/power-bi-tiles-WA104379699.aspx?assetid=WA104379699&sourcecorrid=bd27d848-b8e6-4da0-a848-e81d193dd317&searchapppos=1


2.       How can we provide security for our content so that – the content the dashboard uses only shows the content that the logged in user has permission to
a.       For instance, I have 5 projects (Project 100, 101, 102, 103, 104 for instance) running – we have built a dashboard to show project progress, costing details, resource details etc.
b.       Now when Project Manager 1 of Project 100 comes in, the same dashboard should show data only about Project 100 and not any other Project?
c.       That is how, how does the data security transcend to the project dashboard so that the project dashboard automatically filters and shows only the data authorized for the logged in user
Response :
This scenario is called as dynamic security and is implemented by creating a bridge table which maps each user with the projects he has access to.

Power bi supports dynamic security using analysis services connectors or enterprise gateways.

For more information you can read following articles

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-analysis-services-connector-indepth/

https://msdn.microsoft.com/en-us/library/hh479759.aspx

  
3.       Last, on the licensing
a.       We have a company of 500 users
b.       There is 1 Power BI pro license – for a Developer – who will create the Dashboard (Pulling data from an On-Premise SQL Server) and then Publish to Power BI
c.       Now, he shares this Dashboard to the other 499 users – all of these have only Power BI free license assigned
d.       So is it right to say, we have only 1 Power BI pro license and 499 Power BI free licenses?

Response : What is said is correct. 1 Pro license and 499 free licenses. The first time you share you do get a message that asks you to upgrade to Pro License for free but on clicking cancel you can see the shared dashboard.


Comments

  1. Ben ClarkFebruary 25, 2023 at 6:50 PM

    Thanks for sharing this informative article on Power BI Clarifications with important question and solution. If you have any requirement to Hire PowerBI Developers for your project. Please visit us.

    ReplyDelete

Post a Comment

Popular posts from this blog

Using External Content Types with Stored Procedures with Input Parameters

Image
You must have tried External Content Types - the exciting new feature in SharePoint 2010 to connect to an external SQL table and provide a list where it lists, creates, updates data straight into the SQL table. People always wonder, how do you get a ECT to work with a Stored Procedure, one that has input parameters. You could do it this way... Step 1: In your SharePoint Designer 2010, create a new external content type Step 2: Connect to your SQL Server and then make sure you see the Routines (your stored procedures must be listed here) Step 3: Rt Click on the Stored Procedure name and create operations for "Read Item" and "Read List" - both are required for the External Content Type's SharePoint list to be created. During both these wizards, in the Input Parameters, your SP's Input Parameter will be listed. Here, you need to create a filter, which sends out it's value to the SP's filter. For example, if your SP's Input Parameter is @Emp
Read more

NAV 2009 Issues in Role Tailored Client

Image
Role tailored client issue Changing stored procedure to 64 bit in NAV 2009 Did install Dynamics NAV 2009 on windows 2008 64 bit / Windows 7 65 bit. When trying to connect to the database in classic client I got this error. The following SQL server error or errors occurred: 17750,“42000”,[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL C:\Program Files (x86)\Microsoft Dynamics NAV\60\Database\xp_ndo.dll, or one of the DLLs it references. Reason: 193(failed to retrieve text for this error. Reason: 15100). SQL: INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)} The reason for this error is that the installed xp_ndo.dll is 32 bit and not 64 bit. My solution was simple to replace xp_ndo.dll with the 64 bit version. 1. Stop SQL server 2. Copy \\vedfssrv01\DynamicsNAV2009\W1\DVD\Sql_esp\x64\ xp_ndo_x64.dll to C:\Program Files (x86)\Microsoft Dynamics NAV\60\Database 3. Rename existing xp_ndo.dll to xp_ndo_x32.dll 4. Rename xp
Read more