Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r0Tmg-005rd5-7O for pgsql-bugs@arkaria.postgresql.org; Tue, 07 Nov 2023 21:38:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r0Tme-00CabU-DG for pgsql-bugs@arkaria.postgresql.org; Tue, 07 Nov 2023 21:38:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r0Tmd-00CaW5-RS for pgsql-bugs@lists.postgresql.org; Tue, 07 Nov 2023 21:38:51 +0000 Received: from mail-qv1-xf2b.google.com ([2607:f8b0:4864:20::f2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0Tma-004SW0-Fk for pgsql-bugs@lists.postgresql.org; Tue, 07 Nov 2023 21:38:49 +0000 Received: by mail-qv1-xf2b.google.com with SMTP id 6a1803df08f44-6711dd6595fso35006766d6.3 for ; Tue, 07 Nov 2023 13:38:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1699393127; x=1699997927; darn=lists.postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=zMzlB+9LeTswrZ65QDK8c3f/SxV6/pIw9P9If3bpp1Q=; b=H58wJUzpUz90EGZMqyXZxMsMZdIfQTJFIURk7WZbev3MbtbZc6OpFQArpR9k6dpSi/ 8nJOInCbSiAv4VlEbVIbW82TvUEPhATMCrbwPuhHS+jEhgtkGvilBbYooS6OHNlXx3Z+ pqMH8S2IBnUQTnJk23dQ+g1Gf6J6vBani2Kbzi3BgZ7tepqC7AxoKgBvMcSqpoNo6PUb QsdPDOIWgwZFAz0jUbpfREo2Zkiw24YE6e1TujCKYm+5F9qEFrooKWuhpZNp6w6mMoIC OaDWyXeutIUHRCTDAxR+AcFIMbFDhekiEBdgtHEwnOzANGhn+MwS3HJdMNawW1ldyUQM +2SA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699393127; x=1699997927; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=zMzlB+9LeTswrZ65QDK8c3f/SxV6/pIw9P9If3bpp1Q=; b=fzZUR72Lp2seHBHdyC9QxEQpyNiV6V6GhFi73ewqvw6XdkZAJcRlzthxAGkqkWzpkM v9xFfNz5k4n+eEOcVFb8tUF6DHQWeGibjmoaI6vQCTCrzGJwyR2lxpXExLkz23Ye2NS1 iiGJaThnZJtHHhsQ3uIOQwJlSG97Z8jyCiEcmrLSHG9u0MNkChS4giOGzJsGbr2m3wMJ 6BXT8DrEKhnqNRDzD5nqSbsMfdEmf0pSA/nsVcDok0CYVAIM8c8xMJMT3Hts+ysJTf0Q imh+MPn0Jat3XuPpxrlPuAYtgyTu7GbMWCKsrIRUQaPsWiSTKi2J0xkjXHYMRuijDTFq 4zpw== X-Gm-Message-State: AOJu0YyZnNWXzMzPVuLOcBAyeCWDLk5r/zUG7H9PSYucmxSvcxbfAj1V r9V5EyLQgsCDN4XpRpWj4B3qMA== X-Google-Smtp-Source: AGHT+IEwNhd849HGSTA2PeK3rHTAYH78GZeXYEB6wHr7LndxGrTBjhnn8r8vS8T0fGPJmydDlnGUQg== X-Received: by 2002:ad4:5cc4:0:b0:671:3493:61db with SMTP id iu4-20020ad45cc4000000b00671349361dbmr33950159qvb.51.1699393126981; Tue, 07 Nov 2023 13:38:46 -0800 (PST) Received: from ?IPV6:2605:a601:9122:d800::2bb? ([2605:a601:9122:d800::2bb]) by smtp.googlemail.com with ESMTPSA id pi41-20020a05620a37a900b00774652483b7sm320225qkn.33.2023.11.07.13.38.46 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 07 Nov 2023 13:38:46 -0800 (PST) Content-Type: multipart/alternative; boundary="------------TPHjZh86CaPoyTtQiT0x5dlG" Message-ID: Date: Tue, 7 Nov 2023 16:38:45 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.15.1 Subject: Re: BUG #18186: Question around integration To: "David G. Johnston" Cc: wiehan.kielblock@gmail.com, pgsql-bugs@lists.postgresql.org References: <18186-94b0abd22be68365@postgresql.org> <43d8cb40-e8d3-7be8-02f2-1aaf4c9c3e88@dunslane.net> Content-Language: en-US From: Andrew Dunstan In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------TPHjZh86CaPoyTtQiT0x5dlG Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 2023-11-07 Tu 16:01, David G. Johnston wrote: > On Tue, Nov 7, 2023 at 1:59 PM Andrew Dunstan wrote: > > > On 2023-11-07 Tu 08:03, PG Bug reporting form wrote: > > The following bug has been logged on the website: > > > > Bug reference:      18186 > > Logged by:          Wiehan Kielblock > > Email address: wiehan.kielblock@gmail.com > > PostgreSQL version: 16.0 > > Operating system:   Azure saas > > Description: > > > > We're trying to use Cube as our OLAP backend for our PowerBI > reports. Cube > > make use of Postgres as a backing database. Currently we're > using SQL Server > > to connect our reports using Tabular Object Model. > > > > Can you please advise if it is possible to connect to a Postgres > database > > using Tabular Object Model and if so, what is the format to do that? > > > > We have been unable to to use a postgress connection string > through ssas to > > use the tabular object model. > > > > None of the questions you ask relates to a bug. Questions about > how to > use PostgreSQL should be asked on the pgsql-hackers email list. See > > > > Please don't bug -hackers with this.  -general is the list you want to > ask. Quite right. Apologies for a moment of brain fade. cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------TPHjZh86CaPoyTtQiT0x5dlG Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


On 2023-11-07 Tu 16:01, David G. Johnston wrote:
On Tue, Nov 7, 2023 at 1:59 PM Andrew Dunstan <andrew@dunslane.net> wrote:

On 2023-11-07 Tu 08:03, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference:      18186
> Logged by:          Wiehan Kielblock
> Email address:      wiehan.kielblock@gmail.com
> PostgreSQL version: 16.0
> Operating system:   Azure saas
> Description:
>
> We're trying to use Cube as our OLAP backend for our PowerBI reports. Cube
> make use of Postgres as a backing database. Currently we're using SQL Server
> to connect our reports using Tabular Object Model.
>
> Can you please advise if it is possible to connect to a Postgres database
> using Tabular Object Model and if so, what is the format to do that?
>
> We have been unable to to use a postgress connection string through ssas to
> use the tabular object model.
>

None of the questions you ask relates to a bug. Questions about how to
use PostgreSQL should be asked on the pgsql-hackers email list. See
<https://www.postgresql.org/support/>


Please don't bug -hackers with this.  -general is the list you want to ask.



Quite right. Apologies for a moment of brain fade.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com
--------------TPHjZh86CaPoyTtQiT0x5dlG--