So far, I have been testing Dremio and it a great tool to get to the data quickly.
I followed the instructions to get PowerBi going
I have experimented with both localhost and accessing the cluster node via a remote IP address. This all works great when a client is utilizing PowerBi Desktop. However, now the next step is to publish this content so that PowerBi App, Browser and Embedded can be populated via a Data Gateway into the PowerBi Service.
I can publish, manually, using Data Connectivity Mode = Import, however I am unable to setup a connection to refresh this data with a Gateway
I am NOT able to publish, manually, using Data Connectivity Mode = DirectQuery. This results in a 404 error returned by Microsoft.
Therefore setting up a DirectQuery and publishing to the PowerBi Service IS NOT possible. Using a process like this…
I am posting to confirm that my findings above are accurate with others experiences. That Dremio ODBC Connector ONLY supports PowerBi Desktop with DirectQuery or Import Data Connectivity Modes WITHOUT support in publishing to PowerBi Service.
Maybe there is a way to setup a ODBC connection instead?