Can you share the sample dataset with error screenshot?. Generally pivot will be done with in a sample table.
Union and joins are used to combine tables. so getting confused with your question
If you open the data source tab and pivot is not available - it is related to the data source - if you are using a live dataset directly from some database sources you will not be able to pivot - in that case try an extract or custom SQL
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you for the reply.
I did tried with both Live and Extract connection, however still same behavior persists.
Just to share an update, now after pivoting the table no data is visible.
I have confirm I can pivot the dataset.
Any further steps I can test to fix the issue?
Also there is no error message thrown.
There is no error message thrown while pivoting the tables.
1 of 1 people found this helpful
Please attach your twbx workbook and I will take a look at it