Forum Discussion
RakeshSinghr
Resolver I
Resolver IAnalyse in Excel without measure
When connected to power bi dataset in excel using analyse in excel feature - is there a way to set default measure? Currently when dimension attributes r selected its displaying as a cross join u...
Excel doesnt seem to work just based on the table fields, it needs a measure like rowcount to bind dimension attributes togther.
HI RakeshSinghr,
I don't think you can modify the exported file content/design that generated from 'analyze in excel' feature.
You can open the file to design your pivot table and save change but it is impossible to directly apply to the default generated files.
Regards,
Xiaoxin Sheng
RakeshSinghrExcel doesnt seem to work just based on the table fields, it needs a measure like rowcount to bind dimension attributes togther.