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 > >>> > >>> > > > > >>> > >>> > > > >>> > >>> > > >>> > >>> > >>> > >> > >>> > > >>> > >> >
