Forum Discussion
how to: Direct Query hierarchical (two level) sql query into Power BI
Hello, I would like to know how I can direct query the sql code for the hierarchical (two level) sql query. I would like to import the sql code for the data output below to PowerBI, PLEASE NOTE I AL...
Hi OPS-MLTSD
I can't find any official documents discussing about it.
Based on my knowledge, Power BI doesn't support "hierarchial data" to generate dynamically when data source is with direct query.
Could you try to paste the "hierarchical sql query" in the "SQL statement" under the "Advanced options"?
Or create calcualted columns in Power BI to create hierarchical columns?
Video:
How to create hierarchial with power bi
Best Regards
Maggie
because of privacy reasons I can't paste the query. Is there any other way?