Forum Discussion
Get Data From Excel Pivot Table
Hi folks, My source is a specific Excel pivot table exported automatically from MS Project visual reports. This pivot table have 2 hierarchical level in columns : Year and Month, as shown here. Unha...
Hi Anonymous ,
Could you please make some adjustments in the excel file just as below screenshot? Then you can import the excel file into Power BI Desktop after adjusted and make other transformations base on your requirement. Any comment or problem, please feel free to let me know.
Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.