Forum Discussion
Use Power BI datasets and DirectQuery Connection Changes Date Type???
Hello. I am trying to use a Power BI dataset and add some tables for a new report. In order to do this I use the DirectQuery connection. There is an important line graph that is showing mo...
Young_G_Han , If you are using date, then you can use date hierarchy. But that you can do only on non key/join column.
If you use month and year, I doubt you can use date hierarchy
Of course I use date hierarchy and the table and columns are connected to the transaction date.
Is this the key/join column?
But the problem is that I could use the same function with the data used by Transform data.
I want this kind of graph but after I start to use the DirectQuery connection, all month name appears on the graph.
