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:
[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.
@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
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
