Hi guys. I absolutely love your product. I have two questions:
Why can't I use Count Distinct in regular pivot tables that are sourcing data that isn't loaded into the Data Model?
In newer iterations of Excel, when I connect an excel file to a data source in a SQL Server Database for the first time, the connection no longer saves to Existing Connections the way it used to in 2013 and earlier. Why is that, and would you ever change it back to the way it was before?
Thank you for making such an incredible product. It is my number one tool in data analytics and has been for a decade.
bposeley49 karma
Hi guys. I absolutely love your product. I have two questions:
Why can't I use Count Distinct in regular pivot tables that are sourcing data that isn't loaded into the Data Model?
In newer iterations of Excel, when I connect an excel file to a data source in a SQL Server Database for the first time, the connection no longer saves to Existing Connections the way it used to in 2013 and earlier. Why is that, and would you ever change it back to the way it was before?
Thank you for making such an incredible product. It is my number one tool in data analytics and has been for a decade.
View HistoryShare Link