Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there a way to export data model from PBI Desktop to Excel Power Pivot?
I mean export the full model with measures, calc columns, and tables.
I found the way to copy only datasets from query editor or data view to excel but it is missing measures and calc columns and actually import data to excel worksheet istead of pover pivot data model
Is this possible to do?
Solved! Go to Solution.
Hi @Anonymous ,
Maybe you can take a look at following blog to use excel to retrieve ssas instance data, it can extract calculate fields.
Using Microsoft Excel to Retrieve SSAS Tabular Data
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
Maybe you can take a look at following blog to use excel to retrieve ssas instance data, it can extract calculate fields.
Using Microsoft Excel to Retrieve SSAS Tabular Data
Regards,
Xiaoxin Sheng
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |