Forum Discussion
Solved
How to enable Gateway Connection using Direct Query for PBI Dataset and Analysis Services (preview)?
We've created a report, combining an Excel file on-prem and a direct query connection to an existing dataset in Power BI Service, using this feature avaialble in preview. Once published, the Powe...
Thank you for the tip but we had that box checked. However, it was a great point that led me to the fix.
Not sure if it's like that for everyone, but in our case cloud to cloud (report to source) doesn't work with a gateway connection but only via authentication. So here is the process:
- I mapped the gateway connection for the on-prem file,
- skipped the Optional gateway for the PBI dataset and
- clicked Apply and
- then went to Data Source Credentials,
- clicked Edit credentials and
- authenticated using OAuth2 for the PBI dataset connection.
Then it takes a few minutes and a closing/opening of the browser tab or clicking refresh icon on the report itself to reload the page and display visuals.
Go to Manage Gateways.
At the bottom of the gateway cluster settings tick:
At that point if you set up a folder path to the excel file on prem it all should work.
I believe the explanation is that a gateway is all or nothing.