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:
Power BI Data Gateway does not recognize Dremio add in unless admin is logged into the data gateway
We have had the Dremio ODBC driver running and working on Power BI On-Premises data gateway server for over 1 year. But when we upgraded to Power Bi data gateway Oct 2020 release, it 'broke' Dremio. The Dremio add in will not be recognized by data gateway unless an admin user is logged into the data gateway. It refuses to stay 'active' when a user is not acive in data gateway. How do we resolve this? We have tried running dremio-connector-odbc1.4.2.1003_1-win64, and dremio-connector-odbc-1.5.1.1000-win64. Neither release seem to help the issue with it not staying lonine and active in the Azure PBi gateway. A user has to stay logged into the server for the Dremio data connector to remain ‘active’. If the user logs off the gateway retains the data connection path, but it drops the dremio connection add in and no longer recognizes it. Tests show that once it is no longer showing ‘active’ the Power Bi reports don’t connect
