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 HIVE dim/fact table only?* Thank you very much On Thu, Nov 9, 2023 at 3:03 PM Xiaoxiang Yu <x...@apache.org> wrote: > 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 'Reinstalled the Power Bi to 32 bit and use 32 bit ODBC. All > works. ' > > At the same time, maybe you can retry in a Windows vm, > I guess you can make it correct in a new and clean env (or latest OS > version). > ------------------------ > With warm regard > Xiaoxiang Yu > > > > On Thu, Nov 9, 2023 at 3:30 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> wrote: > > > 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, 2023 at 4:46 PM Xiaoxiang Yu <x...@apache.org> wrote: > > > > > 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++-windows.jpeg] > > > > > > > > > ------------------------ > > > With warm regard > > > Xiaoxiang Yu > > > > > > > > > > > > On Wed, Nov 8, 2023 at 4:00 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> > > wrote: > > > > > >> 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 <x...@apache.org> 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 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 > > >>> - OS : Windows 11 Home China Version, 22H2 > > >>> - Kylin : Kylin 5.0.0-beta in docker image(downloaded from > > dockerhub) > > >>> - Docker Desktop : latest(4.25.0) > > >>> - WSL : latest/ubuntu > > >>> - Power BI Desktop : 2.122.1066.0 64-bit(October 2023) , the > latest > > >>> version which download from Microsoft Store > > >>> - ODBC Driver: 3.1.12, visit > > >>> https://download.kyligence.io/#/download , > > >>> find the link of 'Kyligence ODBC Driver for Windows 64 bit', the > > >>> downloaded > > >>> file name should similar to > > 'Kyligence.ODBC.3.1.12.1008.Windows.x64.exe' > > >>> > > >>> > > >>> Here is how to prepare a Kylin Instance in Windows: > > >>> 1. Install Docker Desktop and WSL, refer > > >>> > https://learn.microsoft.com/zh-cn/windows/wsl/tutorials/wsl-containers > > . > > >>> 2. Execute command( > > >>> https://hub.docker.com/r/apachekylin/apache-kylin-standalone) in WSL > > >>> shell(default is Ubuntu) > > >>> to start Kylin Instance. > > >>> 3. Build a segment of Model 'sample_ssb' and make sure the job > > >>> succeeds. > > >>> 4. Install Power BI Desktop(it is free to use) > > >>> 5. Install and configure Kyligence ODBC Driver, and test the > > >>> connectivity > > >>> 6. 'Get Data' from Power BI Desktop, and preview table rows > > >>> > > >>> > > >>> Here is my configuration of 'ODBC Datasource': > > >>> - Host : 127.0.0.1 > > >>> - Port : 7070 > > >>> - Username : ADMIN > > >>> - Password : KYLIN > > >>> - Project : learn_kylin > > >>> > > >>> Here is my suggestion: > > >>> Unluckily, I didn't have the same software as yours. But I think > > you > > >>> should > > >>> check if you configured it correctly. > > >>> If you cannot make it correct, please go to 'Kyligence ODBC > Driver > > >>> DSN > > >>> Setup', > > >>> click the 'Logging Options', and set proper Log Level and Log Path. > > Then > > >>> you > > >>> should retry and check if log files show any helpful message. > > >>> > > >>> Here are some of my screenshots: > > >>> 1. Step 5, ODBC DSN Configuration, > > >>> > > >>> > > > https://kylin.apache.org/images/Kylin-ODBC-DSN/odbc-kylin5-powerbi-desktop-windows-1.jpeg > > >>> 2. Step 6, Power BI Desktop, > > >>> > > >>> > > > https://kylin.apache.org/images/Kylin-ODBC-DSN/odbc-kylin5-powerbi-desktop-windows-2.jpeg > > >>> > > >>> Hope this reply will help you fix your problem. > > >>> > > >>> ------------------------ > > >>> With warm regard > > >>> Xiaoxiang Yu > > >>> > > >>> > > >>> > > >>> On Tue, Nov 7, 2023 at 7:18 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> > > >>> wrote: > > >>> > > >>> > 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 <x...@apache.org> > wrote: > > >>> > > > >>> > > 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 <na...@vnpay.vn.invalid > > > > >>> > wrote: > > >>> > > > > >>> > >> 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 much > > >>> > >> > > >>> > >> [image: image.png] > > >>> > >> > > >>> > >> On Tue, Nov 7, 2023 at 4:51 PM Xiaoxiang Yu <x...@apache.org> > > >>> wrote: > > >>> > >> > > >>> > >>> 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 > > >>> > >>> > > >>> > >>> > > >>> > >>> > > >>> > >>> On Tue, Nov 7, 2023 at 5:40 PM Nam Đỗ Duy > <na...@vnpay.vn.invalid > > > > > >>> > >>> wrote: > > >>> > >>> > > >>> > >>> > 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 > > >>> > >>> > installation > > >>> > >>> > package. If Microsoft Visual C++ 2015 is already installed > > on > > >>> your > > >>> > >>> > machine, > > >>> > >>> > this step will be skipped. > > >>> > >>> > 2. > > >>> > >>> > > > >>> > >>> > A running Kyligence Enterprise server > > >>> > >>> > > > >>> > >>> > Kyligence ODBC Driver will connect to a Kyligence > Enterprise > > >>> > server > > >>> > >>> to > > >>> > >>> > verify whether the connection works, so make sure the > > >>> Kyligence > > >>> > >>> > Enterprise > > >>> > >>> > is running properly. > > >>> > >>> > > > >>> > >>> > > > >>> > >>> > Thank you and best regards > > >>> > >>> > > > >>> > >>> > On Tue, Nov 7, 2023 at 3:46 PM Xiaoxiang Yu <x...@apache.org > > > > >>> 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 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. > > >>> > >>> > > > > >>> > >>> > > >>> > > > >>> > > https://kyligence.io/resources/kyligence-odbc-driver-for-apache-kylin-2/ > > >>> > >>> > > 2. > > >>> > >>> > > > > >>> > >>> > > > > >>> > >>> > > > >>> > >>> > > >>> > > > >>> > > > https://docs.kyligence.io/books/v4.6/en/Analyst-and-Business-Users-Guide/integration/ > > >>> > >>> > > > > >>> > >>> > > > > >>> > >>> > > ------------------------ > > >>> > >>> > > With warm regard > > >>> > >>> > > Xiaoxiang Yu > > >>> > >>> > > > > >>> > >>> > > > > >>> > >>> > > > > >>> > >>> > > On Tue, Nov 7, 2023 at 3:14 PM Nam Đỗ Duy > > >>> <na...@vnpay.vn.invalid> > > >>> > >>> > wrote: > > >>> > >>> > > > > >>> > >>> > > > Dear Sir/Madam > > >>> > >>> > > > > > >>> > >>> > > > Our company is using report server on premise. Please > > advise > > >>> me > > >>> > the > > >>> > >>> > > > integration guidelines in two scenarios: > > >>> > >>> > > > > > >>> > >>> > > > 1. POC period: > > >>> > >>> > > > Power BI report server: Windows 10 > > >>> > >>> > > > Kylin 5.0 in docker file downloaded from official kylin > > >>> website > > >>> > >>> > > > > > >>> > >>> > > > 2. Development period: > > >>> > >>> > > > Power BI report server: Windows 10 > > >>> > >>> > > > We plan to not use docker this time: Kylin 5.0, Hive, zoo > > >>> keeper, > > >>> > >>> > hadoop > > >>> > >>> > > in > > >>> > >>> > > > Ubuntu > > >>> > >>> > > > > > >>> > >>> > > > Thank you very much and best regards > > >>> > >>> > > > > > >>> > >>> > > > > >>> > >>> > > > >>> > >>> > > >>> > >> > > >>> > > > >>> > > >> > > >
