Connectors and data questions
Ask the community and the AI Insights 365 team. Search first: your answer may already be here.
-
0votes1answer35viewsHow does the on-prem gateway architecture work?
Can you explain how the gateway fits into a hybrid setup?
-
0votes0answers27viewsIs there a limit on the number of rows a chart can show?
My table has hundreds of thousands of rows. Will charts cope?
-
0votes0answers29viewsCan I connect Salesforce reports, not just objects?
We have custom Salesforce reports. Can I pull those in directly?
-
0votes0answers27viewsWhat happens to my reports if I delete a datasource?
I want to clean up old datasources. Will reports that use them break?
-
0votes0answers30viewsHow do I connect Snowflake with key-pair authentication?
Our Snowflake account doesn't allow password logins. Is key-pair auth supported?
-
0votes0answers29viewsCan I schedule a datasource refresh at a specific time?
Our warehouse loads at 6am. Can I make reports refresh right after that?
-
0votes0answers24viewsDoes PostgreSQL work the same way as SQL Server?
We're on PostgreSQL. Are there any differences in what the AI can do with it?
-
0votes1answer35viewsCan I use Python to analyse my data?
Some of our analysis needs pandas. Can I run Python inside AI Insights 365?
-
0votes1answer39viewsWhy do I get a timeout when connecting to my database?
Adding a SQL Server datasource fails with a timeout. What should I check?
-
0votes1answer33viewsDoes the app copy my database or query it live?
Do you store a copy of our database, or run queries against it when someone opens a report?
-
0votes1answer31viewsHow fast can I get from a CSV file to a chart?
I just need a quick chart from a CSV for a meeting. What's the fastest route?
-
0votes1answer37viewsHow do I connect Google Sheets to a dashboard step by step?
Is there a walkthrough for going from a Google Sheet to a finished dashboard?
-
0votes1answer29viewsCan I rename a datasource after creating it?
I named my datasource 'test2' and now it shows everywhere. Can I give it a proper name?
-
0votes1answer32viewsWhy does my CSV upload show the wrong column types?
Numbers in my CSV are being treated as text, so I can't sum them. How do I fix it?
-
0votes1answer36viewsWhere is my uploaded data stored and how much space do I have?
Our IT asks where uploaded files live. Is there a storage limit per organisation?
-
0votes1answer32viewsHow do I set up relationships between two tables?
I have Sales and Countries tables. How do I join them so I can see sales by region?
-
0votes1answer53viewsCan one report use data from several datasources?
I want SQL sales data and an Excel budget in the same report. Is that possible?
-
0votes1answer36viewsHow does the gateway keep our database credentials safe?
Security is asking whether our SQL password is stored in the cloud. How does the gateway handle it?
-
0votes1answer36viewsWhat is the Data Gateway and when do I need it?
I keep reading about a gateway. Do I need it to connect my database?
-
0votes1answer32viewsHow many datasource types are supported?
Before we commit, which databases and services can AI Insights 365 connect to?