Hi all,
I have a Data Model with a couple million rows.
I can't load this as a worksheet in Excel 2013, so i've converted this into a data model.
I want to be able to easily filter through my data and return relevant results, ideally with the help of Slicers.
How can I input my Data model into a pivot table?
When using PowerPivot, it says "The connection you're trying to open was created with PowerQuery."
Is there an easy way to manipulate data when it contains more than the 1,048,567 Rows?
I have a Data Model with a couple million rows.
I can't load this as a worksheet in Excel 2013, so i've converted this into a data model.
I want to be able to easily filter through my data and return relevant results, ideally with the help of Slicers.
How can I input my Data model into a pivot table?
When using PowerPivot, it says "The connection you're trying to open was created with PowerQuery."
Is there an easy way to manipulate data when it contains more than the 1,048,567 Rows?
