Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Enhance the Azure Analysis Services connector to dynamically generate and push down DAX statistical queries (like MEDIAN and PERCENTILE.INC), enabling natively supported Box Plots and Histograms while keeping data in External (Live) Mode.

The Use Case: As organizations increasingly adopt Microsoft Fabric and centralized Semantic Models (via Azure AS / XMLA endpoints) to handle massive enterprise datasets, Spotfire data scientists need to leverage Spotfire's statistical visualizatio...
about 2 months ago in Spotfire / Data Access 0 Future Consideration

Support for opening Microsoft Purview-protected Excel files in Spotfire

Currently, when an Excel file is saved with the "Strictly Confidential" sensitivity label, the user who saved the file can open the file normally in Excel, but cannot open the same file in Spotfire. It would be appreciated if Spotfire could suppor...
26 days ago in Spotfire / Data Access 0 Future Consideration

Azure Analysis Services Authentication Support OAuth2

Currently, the Microsoft SQL Server Analysis Services / Microsoft Azure Analysis Services connector only supports authentication methods: Windows authentication OR Username and password. The (now deprecated) Custom Spotfire® Connector to Azure SQL...
12 days ago in Spotfire / Data Access 0 Future Consideration

Hide the Actual Password in Saved Credentials Settings

When a connection data source has saved credentials, the password field may display dots corresponding to the actual password length. If the actual password is retained in the field, users may be able to reveal it using external tools. We would l...
13 days ago in Spotfire / Data Access 0 Future Consideration
272 VOTE

Open analysis file without data

When doing support, we need to open DXP file with sometime HUGE amount of data. It would be useful to be able to open a DXP file in Spotfire Analyst, with a special option "Without Data". So we could just have a look to * how many data source the...
almost 10 years ago in Spotfire / Data Access 13 Future Consideration
264 VOTE

Add columns by matching on calculated columns

When adding columns from External data, it is currently not possible to match on columns that have been calculated in DXP.This could be useful for several purposes:* if casting of datatype is needed to perform the matching* if string trimming is n...
over 10 years ago in Spotfire / Data Access 5 Future Consideration

Support Parameterization of SELECT Clause in Custom Queries

Enable parameterization of the SELECT statement (column list) within custom SQL queries in Spotfire. Currently, query parameters can be used in filters and conditions, but not to dynamically control which columns are returned. This limits flexibil...
7 months ago in Spotfire / Data Access 1 Future Consideration
133 VOTE

Support temporary tables in data connections

When retrieving on-demand data Spotfire's information designer supports creating temporary tables to avoid huge WHERE clauses (link) which can not only be a performance issue but infact hinder a query from being executed completelly. Temporary tab...
over 6 years ago in Spotfire / Data Access 6 Future Consideration
182 VOTE

Better support of web services

When you need to consume data from a web service in Spotfire there are different options like implementing a custom data source, develop an Iron Python script, use an R script on your Stats server or use something like Composite or Jboss Teiid tha...
about 10 years ago in Spotfire / Data Access 5 Future Consideration
145 VOTE

Load Parquet, ORC and Avro data files from Amazon S3 and HDFS

Spotfire should be able to connect to and read Parquet, ORC and Avro files from Amazon S3 and HDFS.
over 8 years ago in Spotfire / Data Access 9 Future Consideration