Forum Discussion
Dynamic columns refresh issue
Hi, I'm having a pivot table as my source table (using SQL connection), the columns are months. When I'm refreshing the dashboard I'm expect to get new month (new column), I'm getting it from the q...
Yes, sorry, that was what I was suggeting, to unpivot it in Desktop. Point a query to your data and edit the query. Choose your "Type" column and then "Transform | Unpivot columns | Unpivot Other Columns", you should get a table like:
Type,Attribute,Value
a,Jan,1
a,Feb,2
a,March,10
b,Jan,15
etc.
Thanks, although I succeeded to pivot the view inside the Power BI Desktop, I'm getting the same issue, when refreshing the data and new column is added it's not automaticcaly selected in the visualisation view.
- Hi - at the moment we don't support dynamic import across a pivot table. What is the pivot table connected to? Could you go directly to that datasource instead?
I have the same issue as described in the subject, I would like to add new columns automatically (or show all columns by default) Is there any update with that functionality ?
