Forum Discussion
HierarchyID display
Well there is a glitch in the matrix.
I connected PowerBI to Adventureworks2014 and entered the simple string
SELECT * FROM [HumanResources].[Employee] in the advanced options/sql statement
and get a messgae - incompatible data type OrganisationNode.
Doing the same with my tables - no error - hierarchyID comes through as if GetString() applied
PowerBI - the software that is almost good.
- Greg_Deckler
Community Champion
Can't answer your question without knowing what a sample row of data actually looks like.
I appreciate your attemp to help, but as I have said and implied in each post its to do with the standard (since 2008) hierarchicalID data type. The rest of the data in the row is irrelevant
And as said in my penultimate post:
"The raw data is exactly as you'll see if you do a select * from AdventureWorks2014.HumanResources.Employee"
Just look at a line in the AdventureWorks2014.HumanResources.Employee table and you will see what I see. My own columns are different headings etc but the hierarchical data is exactly the same.
If someone can tell me how to get that Employee table into a PowerBI Visualisation so the OrganizationNode controls the indentents I'd be happy
- Greg_Deckler
OK, that's great, but to do that, I have to go out and find the AdventureWorks database in question, download it, potentially install SQL Server Management Studio and do a bunch of other investigation. Versus, you just post example data from that row or column and viola, you might get an answer to your question.
