Forum Discussion

Greg_Esres's avatar
Greg_Esres
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
11 years ago

The person who was telling me how this can work was assuming that the Azure SQL server would be filtering the rows based on the user credentials, so that some users would see a subset of the data.

 

It's not clear to me how this can work; it looks to me that Power BI copies the entire dataset and so SQL server no longer has any ability to filter rows by user id.

 

 

andre's avatar
andre
Icon for Memorable Member rankMemorable Member
11 years ago

SQL Azure and SQL Analysis Services are a direct connect mode, no data is cashed in PowerBI.com, row level security certainly works with Analysis Services, but I don't think it will work with SQL Azure becuase user name and password are part of the connection information.

  • Greg_Esres's avatar
    Greg_Esres
    Icon for Helper I rankHelper I
    11 years ago

    I'm not using SQL Analysis Services. I wonder if I need to in order to accomplish my goals? My source is claiming that there is some sort of single sign on capability that would pass through to Azure...haven't seen it yet.

    • andre's avatar
      andre
      Icon for Memorable Member rankMemorable Member
      11 years ago

      My advice would be to implement Analysis Services.  If you already have a power pivot model, it can be imported into Analys Services in under a minute.  You do need an instance of SQL Server Analysis Services to deploy it on though.

       

      Ultimately, Analysis Services is the way to go.

      • Greg_Esres's avatar
        Greg_Esres
        Icon for Helper I rankHelper I
        11 years ago

        "Ultimately, Analysis Services is the way to go."

         

        Argh. My role is data architect and I'm designing the warehouse. I didn't anticipate having to get up to speed on the BI side of things. There's more to it than I expected.