topic Re: we are not able to connect direct query in power bi report server by using starrocks connector in Report Server

we are not able to connect direct query in power bi report server by using starrocks connector

Anonymous — Mon, 02 Dec 2024 06:36:11 GMT

Hi Team

we have StarRocks.mez file(Power bi custom connector) with this custom connector we are able to connect direct query in Power BI Report Server Desktop application, but after publish report in ReportServer we are not able open the report getting below error message

Tested with SQLServer as well got the same error in power BI Report server, but after adding environment variable connecting to SQLServer issue got resolved in report server

So tried the same with StarRocks connection by adding environmental variable but issue still issue exists

Can any one please help on this?

Re: we are not able to connect direct query in power bi report server by using starrocks connector

ChrisMuthmann — Mon, 02 Dec 2024 12:30:31 GMT

A quick search brought me to this page: https://forum.starrocks.io/t/starrocks-powerbi-integration/370

Short version as I understood the posting:

Use a MySQL Driver
Unfortunately Microsoft does not provide a MySQL Direct Query driver. CelerData has a PowerBI Direct Query driver for StarRocks only available to enterprise/cloud offerings.

Second result: https://forum.starrocks.io/t/how-to-connect-power-bi-to-starrocks/308

HTH!

Kind regards

Christoph

Re: we are not able to connect direct query in power bi report server by using starrocks connector

Anonymous — Mon, 16 Dec 2024 05:20:16 GMT

Hi, Anonymous

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yongkang Hua