Hi all,
In the interest of time (I'll see first from the community what details are required to help out!) I won't get into a huge amount of details on the query and source data other than it is an SSAS source with multiple tables (one FACT table) and multiple DIM tables.
I am trying to use power query to import data from the source in order to allow me to combine and customise in various reports I need to build for my org. I am using a DAX query (as I have done many times before) to drive the import criteria from the SSAS via power query.
I have created a basic view of the data that I want to import within a blank PBIX file (simply as a sandbox to visualise the filters and expected data output and to use as a comparison for the data when it is extracted from the SSAS with my DAX query).
The DAX statement consists of a basic SUMMARIZECOLUMNS with 'group by', 'filter' and 'summarize' calculations precisely matching the fields and criteria I have applied in the 'sandbox' PBIX but am completely baffled that the results don't remotely match the PBIX when the extract is complete.
I have tried multiple tweaks to the DAX statement and nothing makes it any closer to the PBIX.
The even more bizarre thing is that I have tried to import the data without a DAX query (using the cube navigation / folding functionality in Power Query) but still the data doesnt match.
Is there something I am missing (I'm not familiar with SSAS backend so not sure if there's some magic happening there that I can't see but doesn't materialise using DAX import functionality).
Appreciate this may be a vague without data but looking for some top level principles or pointers before spelling out the data structure and examples further..
Thanks all!
