Forum Discussion

Greg_Esres's avatar
Greg_Esres
Helper I
11 years ago

Global Datasets and Datasources

I want to define datasources and datasets globally and have them available to all users when the log into Power BI. I also want to have the visibility determined by user id. I've been told this is...
Greg_Esres's avatar
Greg_Esres
Helper I
11 years ago

I've already started building out the DW in Azure SQL. I'm a developer/DB guy and these BI tools are new to me. The interaction between Power View, Power Query, Power BI, Power BI Designer and Power Pivot is pretty confusing, and the descriptions of what they do I find on the web aren't at the level of abtraction I find most useful. Overall, it seems that this technology is mostly geared towards peer-to-peer sharing of spreadsheets, rather than the top-down distribution of data that I'm envisioning.

 

The analysts I'm working with are using Tableau, but there high level encouragement to move away from this tool due, in part, to the challenge of user id management. We'd like single sign on capability so that we don't have to construct a lot of separate user ids and roles. We're already using Office 365 and would rather key access off of these existing ids.

andre's avatar
andre
Memorable Member
11 years ago
  • Power View - Visualizations (across platforms and apps)
  • Power Pivot - Reporting model (data load, relationships and calculations), same as technology as Analysis Services but running in Excel
  • Power Query - Data Aquisition and massaging (self service ETL if you will)
  • Power BI Desktop (former Designer) - Power View+Power Pivot +Power Query bundled in one tool outside of Excel
  • Power BI - Software as a Service at PowerBI.com that enables content rendering, development and collaboration that leverages all of the items above

 

This is high livel, but directionally accurate.