Forum Discussion
Data Column Refresh After Unpivot
Hello all,
I have a set of data in Power BI that has months in the columns (Jan, Feb, Mar etc..) everymonth I run the report to get the current month data. So, when I created the report I had all the columns from Jan-Dec in excel but, most had 0's. Now, I run the report, it has the same columns but, the other months are filled out.
In Power BI I have the columns unpivoted so I can easily use it but, it does not refresh the new data. I look in the query and I can see this month is empty eventhough there is data in excel. Can it not refresh the data because it is unpivoted? I am not sure how to correct this. I really don't want to have to create a new dashboard again.
Thank you.
12 Replies
Can you send some example of your data?
After refreshing and now having october data in excel, it will not go into BI.
When you unpivot in powerquery they use the collumns name to unpivot, if you add another collumn to the database, that collumn will not be used.
Do you know how to copy the PowerQUery function in edit mode? Send this and i will create a step to fix this issue.
