Forum Discussion
Missing columns in Excel PowerPivot
Good Day, We are observing/experiencing an interesting behavior of MS Excel when sourcing data from the PBI model published to the service. We have PBI model created/sourced from SQL Server, all...
My issue was solved by changing the setting "Available in MDX" from False to True which makes sense as Excel-queries to the dataset uses MDX instead of DAX. Why it was False in the first place I have no idea.
The picture below is from Tabular Editor.