Forum Discussion

khalilliraqui's avatar
khalilliraqui
Regular Visitor
9 years ago

How does power bi works in depth ?

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 que...
Need Help
Tips and Tricks
djnww's avatar
djnww
Icon for Impactful Individual rankImpactful Individual
9 years ago

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's avatar
    khalilliraqui
    Regular Visitor
    9 years ago

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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