Using Power-BI desktop tool (Report server compatible), the source connection was successful to dremio, once data retrieved from dremio and all the design completed in Power-BI desktop, I saved it in On-premises report server. Unfortunately there is no option to schedule a data refresh. Following additional details for reference.
As second attempt, I have added an additional data-source in the same Power-BI report from a SQL Server view, after publishing report, I can see the configuration for the schedule refresh option, but when the schedule run, it failing with the error:
Please advise, is the dremio only made for cloud edition of Power-BI?
 -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, The given data source kind is not supported. Data source kind: UnknownFunction…
Power-BI desktop version: May 2023 (Report server compatible)
Dremio version: 24.1.0-202306130653310132-d30779f6
Dremio edition: Community