Re: Integrate Power BI report server with kylin

2023-11-09 Thread Xiaoxiang Yu
Looks like the feature Model View (switch is 'kylin.query.auto-model-view-enabled') can help you to query Model directly, but I didn't verify if it works as expected. Maybe you can try and tell us if it works for you. See its explain from https://kylin.apache.org/5.0/docs/configuration/ . --

Re: Integrate Power BI report server with kylin

2023-11-09 Thread Nam Đỗ Duy
Thank you Xiaoxiang, I change the method to PowerBI connector (mez file) and it works with mez. I will try workarount with ODBC later. I have another question: *From power BI, can I access the cube through ODBC/mez or access kylin by custom query because after browsing, in power BI, I see only the

Re: Integrate Power BI report server with kylin

2023-11-09 Thread Xiaoxiang Yu
It is possible that you can ask your question on PowerBI's forum? It is looks like a common issue for PowerBI. Here is a link I found : https://community.fabric.microsoft.com/t5/Issues/ODBC-ERROR-Driver-could-not-be-loaded-due-to-System-Error-126/idc-p/707282/highlight/true#M44488 . He said 'Reins

Re: Integrate Power BI report server with kylin

2023-11-08 Thread Nam Đỗ Duy
Thank you Xiaoxiang, both the link you sent me and chatgpt told me that this error comes from Visual C++ Redistributable for Visual Studio 2015 but I install/reinstall this component many times already still having the same problem Take a rest now and before retrying with this ODBC On Wed, Nov 8,

Re: Integrate Power BI report server with kylin

2023-11-08 Thread Xiaoxiang Yu
I guess your situation maybe similar to this link: - https://dba.stackexchange.com/questions/238135/odbc-error-for-oracle-client-12-2-0-1 Here are some librays that I installed on my PC. (My PC is a single language version, its display language can not change to English.) [image: check-visual-c

Re: Integrate Power BI report server with kylin

2023-11-08 Thread Nam Đỗ Duy
Hi Xiaoxiang, I got this error when configuring the ODBC, it said the dll file was not found but in fact it is there in the location. Please kindly advise... Thank you very much [image: image.png] On Wed, Nov 8, 2023 at 2:25 PM Xiaoxiang Yu wrote: > Hi, > This morning, I verified the Kyli

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Nam Đỗ Duy
Thank you soo much, let me double check every single thing and will let you know soon. On Wed, Nov 8, 2023 at 2:25 PM Xiaoxiang Yu wrote: > Hi, > This morning, I verified the Kyligence ODBC Driver's connectivity > with Kylin 5.0.0-beta, it works well on my Windows PC, and I can preview > the

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Xiaoxiang Yu
Hi, This morning, I verified the Kyligence ODBC Driver's connectivity with Kylin 5.0.0-beta, it works well on my Windows PC, and I can preview the table data in the Power BI application correctly. Here is my PC and software information: - PC : A laptop with 4 cores CPU and 16GB RAM

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Nam Đỗ Duy
Hi Xiaoxiang, I downloaded that file but the error is still the same, please kindly investigate and advise me. Thank you very much On Tue, Nov 7, 2023 at 5:15 PM Xiaoxiang Yu wrote: > I need some time to try to reproduce and find the cause, but before that, > could you re-download another drive

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Xiaoxiang Yu
I need some time to try to reproduce and find the cause, but before that, could you re-download another driver from https://download.kyligence.io/#/download have another try ? With warm regard Xiaoxiang Yu On Tue, Nov 7, 2023 at 5:58 PM Nam Đỗ Duy wrote: > Thank you Xi

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Nam Đỗ Duy
Thank you Xiaoxiang, please see the attached photo and advise me the following: 1. I setup the file of x64, is it correct? 2. I run docker kylin 5.0 on Windows 10 Enterprise, mapping port of docker to 7070:7070 but it showed error as attached file. please advise the configuration. Thank you very

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Xiaoxiang Yu
Oh, you just ignore the 'A running Kyligence Enterprise server', since you have a Kylin 5 server, you can replace it with your Kylin 5 server. That is because I know that these two products share the same API, metadata, and the core design . With warm regard Xiaoxiang Yu

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Nam Đỗ Duy
Hi Xiaoxiang, In order to use Kylin ODBC, do I need to buy separate license of Kyligence to use it? Prerequisites 1. Microsoft Visual C++ 2015 During the installation of Kyligence ODBC Driver, Microsoft VC++ will be installed first and redistributable is already embedded in the ins

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Nam Đỗ Duy
Thank you Xiaoxiang, downloading it now and try… Best Regards On Tue, 7 Nov 2023 at 15:46 Xiaoxiang Yu wrote: > Kylin Team didn't release a suitable driver at the moment, but you can try > an ODBC > driver from Kyligence(a vendor of Kylin). I did not verify but I supposed > it should > work fo

Re: Integrate Power BI report server with kylin

2023-11-07 Thread Xiaoxiang Yu
Kylin Team didn't release a suitable driver at the moment, but you can try an ODBC driver from Kyligence(a vendor of Kylin). I did not verify but I supposed it should work for 5.0.0-beta. Please let us know if it can meet your needs. Here are the download and document links by its website: 1. ht