When I use the ODATA Connector to consume SharePoint List Data the data is loaded as multidimensional data...this leads to the effect that I can't not only use the grid view in the data source pane but also I can't use the pivot option to follow Michaels instructions of his wonderful answer (Re: Gantt Chart Date Sort ). Now my question is, how can I solve this?
I exported the SP list to excel and imported it to Tableau, where it is visualized like it is mentioned here Pivot Data (from Columns to Rows) (in grid view, with pivot option). So I don't think that the data is multidimensional otherwise it would have been display the same way again, right? What can I do?