Is there a way to combine data from a Gateway connector (ODBC) with excel data from OneDrive Business on Power BI Service?
When I create a pbix file containing only excel data from OneDrive the scheduled refresh works perfect but as soon as I add the on-premise data via a gateway connector (ODBC) I run into an error. The error message advise me to install a personal gateway.
I run PBI Desktop on a Windows server. Is it possible to have both on-premise and personal mode installed on the same server?
If not, is there a way to exclude the excel data to be reloaded on the scheduled refresh?
Thanks in advance