Option to import Data (incuding DAX functions) from Excel file data library directly ... not refreshing original data sources.
I use VBA to select JUST the data I need for my analytics of a particular period or category of info in Excel. This way the refresh in Excel is quick and there isn't unnecessary data in the file (in fact it can be sent around easily as the file is quite small) . But with the availabiIit...
Import Of Excel Data Library Tables Linked To Azure Database Does Not Find Server Name
When I connect to an Excel file with Data Library Tables linked to an Azure SQL Database the Import fails to find the Server Name .. In an odd thing, One of the Data Connections for a table actually is the name of a TCP location and it seemed to pick this up and use it as the Server name (?) Othe...
Refresh should import sql statement again before refresh .
If you select a Sql View or Acces query or Excel Data Library source the refreresh should bring in the Sql from the source every time before refreshing the data .. This is important because inevitably sql statements will change over time (i.e. An evolving Where clause). This way the control if t...
Hide Referenced Objects Not Selected To Be Shown In App Workspace Dashboards
In App Workspaces you should be able to select whatever Dash/Rep/Dataset you wish to Publish to you consumers of the App Workspace BUT if you select (for example) only the Dashboard then it really must send along just the Dashboard visible but all Related Objects (reports/datasets) in the "Packag...