How does power bi works in depth ?

[khalilliraqui]

Me and my team mate are very interested about using power Bi in our company, i was charmed by all the beautiful reports and Dashboards that you can create with power Bi, but i have many unanswred questions, i search on the internet but i can't find a convinient answer, here is my questions if someone can aswer them i will be very grateful 🙂  :

1 - Let's supose i've created a model ( 1 fact table and 4 dimention ) i've created an associed report, and then publish it, how data is stocked ? is the cube comutated (like ssas) and stocked as a dataMart or data are stocked in tables and the agregation query are rexecuted when showing the Report or how ?

2 - When i published the report to web, power bi avert me that the report will be public and every one having the link can access it, considering that i will put the report as iframs in our application, is it secure to keep it like this ? or there is a possibility to secure it to be accesed only from application ?

3 - In the Report published i can see all the records of the original database by right clicking in a chart and clicking "show records" i want to let only "show data" and take out "show records" how can i do that ?

[djnww]

Hi @khalilliraqui,

Keep in mind that Power BI is really about self-service Dashboards and Reporting. Quite different to multidimensional/OLAP analysis that you are talking about.

1. Power BI is not multidimentional. You do not create cubes within Power BI Desktop itself.

2. You can embed Power BI in many ways that are secure. There is a webpart for Sharepoint Online. If it is a non-Microsoft product, then GitHub has a number of solutions. I'm not an expert on this, but there are 100% secure options available. I know of a few companies that embed Power BI into their intranets.

3. Unfortunately, I'm not sure what the 'show records' mean. There is 'export data'.

Cheers,

Daniel

[khalilliraqui]

Thank you for your reply,

1 - So when you publish the report and for example you filter by gender, powerbi recalculate the query ? and how data is stored, in tables ?

3 - this is what i'm talking about sory it's in french, the translate is : "show records" the first and "show data" the seconde.

[v-yuezhe-msft]

Hi @khalilliraqui,

Firstly, when you filter your report, Power BI recalculate the query, and in Power BI Service, data that is uploaded from users is typically sent to Azure BLOB storage, and all metadata as well as artifacts for the system itself are stored in Azure SQL Database. For more details, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/ .

Secondly, when you drag raw fields of tables to Values section to create charts, there is no method to take out "show records" option, however, if you drag measures to Values section to create charts, the "show records" option will not appear.

Thanks,
Lydia Zhang