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 ?
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'.
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
Community Support Team _ Lydia Zhang If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.