# Error on integration between Datomic Analytics and Power BI **URL:** \ **Category:** Datomic Cloud\ **Created:** [November 28, 2019, 2:44am UTC](https://forum.datomic.com/t/error-on-integration-between-datomic-analytics-and-power-bi/1266 "2019-11-28T02:44:29Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![bartuka](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@bartuka](https://forum.datomic.com/u/bartuka)\ **Post date:** [November 28, 2019, 2:44am UTC](https://forum.datomic.com/t/error-on-integration-between-datomic-analytics-and-power-bi/1266/1 "2019-11-28T02:44:29Z")
I tried to connect in PowerBI using the analytics support and I did the following steps: - Downloaded Simba Presto Driver for PowerBI - Installed their License - Started to add a new data source to PowerBI over ODBC - Wrote down a connection string to my Presto setup And then things started to get partially wrong. The following picture is the connection window in PowerBI. ![17 PM](https://us1.discourse-cdn.com/flex016/uploads/cognitect/original/1X/93dbf83b3295df9701d7fc96fc0d76b1f6da1d26.jpeg) When I write the optional query to make a simple `select * from table`, everything is fine. The data source is available and I can continue to work on that. However, if I leave this space blank which is good option because I would be prompt with all the available tables in the database and then I choose which ones I wanted to load. But, I got the following error message: ![05 PM](https://us1.discourse-cdn.com/flex016/uploads/cognitect/original/1X/d19979a62efe8634284808bf96de085f0c9a9a37.jpeg) I am not a PowerBI heavy user and could not find what is the query that they are issuing against Presto at this time. Any ideas? Thanks ---
**Author:** ![joshkh](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.datomic.com/joshkh/32/355_2.png) [@joshkh](https://forum.datomic.com/u/joshkh)\ **Post date:** [February 17, 2020, 3:01pm UTC](https://forum.datomic.com/t/error-on-integration-between-datomic-analytics-and-power-bi/1266/2 "2020-02-17T15:01:37Z")
Bump. We are experiencing a similar issue, but with AWS QuickSight. After successfully connecting to the Presto server, QuickSight prompts the user to select a Schema (Datomic database): ![Screenshot 2020-02-17 at 14.45.26](https://us1.discourse-cdn.com/flex016/uploads/cognitect/original/1X/388e58b8a1b7b8c5664c21408e6959ae2e1bba34.png) Upon selecting a Schema, an error occurs: ![Screenshot 2020-02-17 at 14.50.19](https://us1.discourse-cdn.com/flex016/uploads/cognitect/original/1X/1b65e42887c3f3d5b6eea67fe76b9254abd5cca7.png) With the error message `Query failed: Expected string for :db-name`: ![Screenshot 2020-02-17 at 14.40.36](https://us1.discourse-cdn.com/flex016/uploads/cognitect/original/1X/0f2b2df16304b8df2bbff3512ccc2a4d9a0e734f.png) ---
**Author:** ![joshkh](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.datomic.com/joshkh/32/355_2.png) [@joshkh](https://forum.datomic.com/u/joshkh)\ **Post date:** [February 23, 2020, 8:04pm UTC](https://forum.datomic.com/t/error-on-integration-between-datomic-analytics-and-power-bi/1266/3 "2020-02-23T20:04:48Z")
Update: AWS QuickSight only supports Presto with LDAP integration which is not available/configurable in Datomic Analytics. [https://docs.aws.amazon.com/quicksight/latest/user/create-a-data-source-presto.html](https://docs.aws.amazon.com/quicksight/latest/user/create-a-data-source-presto.html) Given Datomic Cloud’s deep integration with AWS, I’m sure that some customers would like to keep their BI in the same ecosystem. I hope this becomes an option in the future. ➕ 1️⃣ ---
**Author:** ![ckws](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.datomic.com/ckws/32/303_2.png) [@ckws](https://forum.datomic.com/u/ckws)\ **Post date:** [August 3, 2020, 2:27am UTC](https://forum.datomic.com/t/error-on-integration-between-datomic-analytics-and-power-bi/1266/4 "2020-08-03T02:27:22Z")
Stupid question on QuickSight: Since it is running in AWS, should connecting to it via QuickSight VPC work? According to the AWS documentation: > If your Presto server allows unauthenticated access, AWS requires that you connect to it securely by using a private VPC connection. I tried it out by - creating a QuickSight VPC using the bastion VPC subnet - allow inbound TCP traffic on port 8989 from the subnet - setup the QuickSight Presto data source server to the bastion instance Unfortunately, I could not connect. Not sure if its PEBKAC issue or still due to QuickSight’s restrictions @joshkh pointed out. ---
**Author:** ![mharris](https://avatars.discourse-cdn.com/v4/letter/m/ce7236/32.png) [@mharris](https://forum.datomic.com/u/mharris)\ **Post date:** [April 21, 2022, 7:56pm UTC](https://forum.datomic.com/t/error-on-integration-between-datomic-analytics-and-power-bi/1266/5 "2022-04-21T19:56:33Z")
Update. I’ve been able to get QuickSight setup as follows: - Create a presto-server running on an EC2 box in a VPC - Create a VPC connector to that VPC within QuickSight’s admin panel - When creating the Data Source in QuickSight, use that VPC connector. Don’t support a password nor SSL (maybe those can be better configured later?)