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.
You've saved me 😁
Happy to hear I was of help! It's an easy solution but not an obvious one, at least it wasn't to me 😅