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/ . ------------------------ With warm regard Xiaoxiang Yu On Thu, Nov 9, 2023 at 6:05 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> wrote: > 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 > > > >>> > >>> > > > > > > >>> > >>> > > > > > >>> > >>> > > > > >>> > >>> > > > >>> > >> > > > >>> > > > > >>> > > > >> > > > > > >
