Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
shekarkola
Regular Visitor

Dremio source not appearing in Power-BI Report server (The given data source kind is not supported)

Using Power-BI desktop tool (Report server compatible), the source connection was successful to Dremio, once data was retrieved from Dremio and all the design was completed in the Power-BI desktop, I saved it in the On-premises report server. Unfortunately, there is no option to schedule a data refresh. 

 

Then, I added an additional data source in the same Power-BI report from a SQL Server view, after publishing the report, I could see the configuration for the schedule refresh option, but when the schedule ran, it failed with the error:

 

I'm a bit confused, the source is already part of the standard sources list (in PowerBI desktop), but it doesn't appear in the report server, is there any additional configuration needed on the Report Server side to make this data source (Dremio) available part of the schedule refresh configuraiton?

 

Error: 

Spoiler
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, The given data source kind is not supported. Data source kind: UnknownFunction..
[1] -1055129594: The current operation was cancelled because another operation in the transaction failed.

PBI-Refresh-error.png

2 REPLIES 2
shekarkola
Regular Visitor

@d_gosbell , I tried it with the following versions of Power-BI Report Server

 

  • May 2023
  • Sep 2023

Thanks for pinning the doc refernce, the source I'm using is not in the list, however, the following statement justifies the error I'm getting expected, I think the Power-BI Report Server really lagged years than the cloud. and I could not understand, why are the data sources made available in Power-BI Desktop (optimized for PBIRS) while those are not supported when published into PBIRS

 

MS-Doc-Ref.png

d_gosbell
Super User
Super User

What is the version of the Report Server? 
Is this Dremio Cloud that you are connected to? If you check here Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn most of the cloud sources do not support scheduled refresh when using Report Server

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.