Questions and answers
Ask the community and the AI Insights 365 team. Search first: your answer may already be here.
-
0votes1answer34viewsDoes 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?
-
0votes1answer32viewsHow 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?
-
0votes1answer38viewsHow 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?
-
0votes1answer30viewsCan I rename a datasource after creating it?
I named my datasource 'test2' and now it shows everywhere. Can I give it a proper name?
-
0votes1answer33viewsWhy 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?
-
0votes1answer37viewsWhere 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?
-
0votes1answer33viewsHow 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?
-
0votes1answer54viewsCan one report use data from several datasources?
I want SQL sales data and an Excel budget in the same report. Is that possible?
-
0votes1answer37viewsHow 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?
-
0votes1answer37viewsWhat is the Data Gateway and when do I need it?
I keep reading about a gateway. Do I need it to connect my database?
-
0votes1answer33viewsHow many datasource types are supported?
Before we commit, which databases and services can AI Insights 365 connect to?
-
0votes1answer35viewsHow do I connect to a file by URL instead of uploading?
Our data is published as a CSV at a URL that updates nightly. Can I connect to the URL directly?
-
0votes1answer33viewsCan I connect an OData feed?
Our ERP exposes OData. Is that supported now?
-
0votes1answer43viewsHow do I connect a REST API as a datasource?
Our CRM has a JSON REST API. Can I use it as data for reports?
-
0votes1answer37viewsHow do I connect a Power BI semantic model?
We already have Power BI datasets. Can AI Insights 365 query them instead of the raw database?
-
0votes1answer29viewsCan I connect Google Sheets and keep it in sync?
Our team updates a Google Sheet daily. Can the report refresh from it automatically?
-
0votes1answer33viewsWhat is the maximum file size for Excel and CSV uploads?
My export is quite large. How big can an uploaded file be?
-
0votes1answer38viewsHow do I connect SQL Server to AI Insights 365?
We have an on-site SQL Server. What do I need to connect it, and is it read-only?
-
0votes0answers27viewsCan I change the language of the interface?
Some of my team prefer Arabic. Is the interface available in other languages?
-
0votes0answers27viewsHow long does it take to set up AI Insights 365 for a team of ten?
We're planning a rollout to ten people. Roughly how long does setup take end to end?