Bigquery can't retrieve data but can see schema due to wrong dataset location
I can retrieve all datasets and tables from Bigquery but when trying to actually get the data (preview or executing custom sql). It happens for Live connection and Elasticube. I use a json service account file to authenticate and withing Google Cloud logging I see that Sisense is trying to fetch the data from US which is not the location the dataset is. I don't know how to fix it. Google cloud log: when trying to fetch data: "Not found: Dataset PROJECT_XX:dataset_xx was not found in location US"1.4KViews0likes3Comments
Changing MySQL Connection String across all data models
My company is upgrading our MySQL version from 5.7 to 8.x. As such, it seems we must change the connection string in all our data connectors referencing the MySQL environment. Is there away of accomplishing this one-shot / globally rather than going into each individual ElastiCube / relevant data table and changing it piecemeal? (Most of our data models are ElastiCubes.) Many thanks!915Views0likes1Comment
Name Type Field Returned as { "Name": "Text" } instead of just Text
All of a sudden, all the name type fields/columns are now returned as { "Name": "John Doe") instead of John Doe. Data source is all from Salesforce tables. Is this a connector issue? It was ok before today. Thanks.903Views0likes1Comment
Error during multinode installation on aws instance
We have three nodes created on AWS, and we've come across an error during the installation which is mentioned below. Error: time="2023-10-13T18:06:38Z" level=fatal msg="[[network] Host [172.31.26.52] is not able to connect to the following ports: [172.31.22.239:2379, 172.31.22.239:2380, 172.31.26.141:2379, 172.31.26.141:2380]. Please check network policies and firewall rules]" [2023-10-13 18:06:38] Error occurred during install_rke section Exiting Installation ... Assistance is appreciated. Thanks.887Views0likes0Comments
Standalone Installer
Good Afternoon Sisense Community, Is there a standalone installer for sisense that we can utilize to install the initial product on our cloud instance? We are getting reports that we will have to allow or whitelist specific URL's to our environment, but are having issues doing so. Do we know if there is an .exe or .msi package that we can utilize?2.1KViews0likes2CommentsExport Excel Files to Azure Blob Storage from websites hosted on Azure App Service
Previously we were using IIS for deploying .NET web application. One export to excel button had been given on UI to export details from database to Excel file and then it will be downloaded to local disc storage. We used Microsoft Office Interop Excel to export file. It was working fine locally. But when we deployed application on Azure App service, it was not downloading files in local disk. Can we export excel file to Azure Blob Storage1KViews0likes0Comments
