Schedule Refresh for Dremio Database Connection

[jajohnson]

Good day,

Is there an issue setting up a Dremio dataset to automatically refresh in Power BI? When I try to schedule a refresh, the Power BI service indicate that schedule refresh for this dataset is not supported.

Any help would be greatly appreciated.

[v-yetao1-msft]

Hi @jajohnson 

Currently, Desktop connects to Dremio does not support custom SQL. Maybe you can bring your thoughts to Ideas.

https://ideas.powerbi.com/ideas/

Best Regard

Community Support Team _ Ailsa Tao

[jajohnson]

Thanks. Is there a way to add custom sql to Dremio Connector? I can see it for other database types but I am only options to load tables from Dremio.

[v-yetao1-msft · Accepted solution]

Hi @jajohnson 

ODBC data source supports scheduled refresh. You need add a ODBC datasource in Manage gateways . For specific operations, you can refer to the following link .

https://rukiatu.com/refreshing-odbc-datasource-from-power-bi-service/

Best Regard

Community Support Team _ Ailsa Tao

[jajohnson]

Thanks for your help.

[jajohnson]

Thanks for your responses.

Is there a way to change the connector used for Data Source without intefering with the model. I have the report built out but it was done using a data source connected via the Dremio Connector but I would like to change the connector to ODBC driver. The ODBC driver is able to facilitate Schedule Refresh?

[jajohnson]

Thanks Anand24.

Are there any plans to have this support included in a near future update?

[Anand24]

@jajohnson ,

I'm not sure if this would be on the priority list for Microsoft right now.

You can have a complete confirmation by raising a support ticket and connecting to the Microsoft Support team. Link

You can also document this as an issue here and put an idea here. The ideas are implemented on Power BI tool based on priority and votes by the Microsoft team.

Kindly mark the previous reply as solution so that other users with similar issue would be helped.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anand24]

Hi @jajohnson ,

Currently Power BI doesn't support scheduled refresh for Dremio data source. It's a limitation.

You may consider manually refreshing or automatic refresh using API calls. 

Here's an example of the API Call:

https://community.powerbi.com/t5/Service/Data-Source-Unsupported-for-Refresh-Asana-API/m-p/1973973

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn