I experienced a strange issue with Power BI today, I might have missed something or there is something unknown to me. This is what I experienced; Power BI does not show all columns when trying to import records from a SQL Server view.
Just for simulating the issue, I created a view with AdventureWorks2014, using three tables, Product, ProductSubCategory, and ProductCategory, and named as vProduct.
USE [AdventureWorks2014] GO CREATE OR ALTER VIEW dbo.vProduct AS SELECT p.ProductID, p.Name Product, s.Name SubCategory, c.Name Category FROM Production.Product p INNER JOIN Production.ProductSubcategory s ON p.ProductSubcategoryID = s.ProductSubcategoryID INNER JOIN Production.ProductCategory c ON s.ProductCategoryID = c.ProductCategoryID; GO
Then I granted SELECT permission to Jack user.
GRANT SELECT ON dbo.vProduct TO Jack; GO
If Jack executes a SELECT against the view, he sees records with all columns.
Now, if Jack connects to the database with Power BI, this is what he sees.
Anyone has experienced this? I made a search but could not find a solution. I might have made a mistake or missed something but could not figure it out. Appreciate if you can share your thoughts or a solution if you have already seen this and sorted out.
I used the latest Power BI version that is May 2017.
Note that I see the same result for both Import and Direct Query.
No comments:
Post a Comment