Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I created a report using data from on premise SQL database and publshed to power bi service. The data was imported not direct query. Report worked, but once I added data from Smartsheet(www.smartsheet.com) and published it, I am unable to use the on-premise gateway. Gateway connection is disabled.
Any ideas on what could be wrong? Or, is this a need that is not supported?
Hi @knpbi,
I am not familiar with smartsheet. Based on my research, smartsheet is an online service application which is used for collaboration and work management.
Currently, when you combine on-premises SQL Server data source and online data source in a dataset, you are not able to use on-premises gateway to schedule refresh for the dataset, this is a known issue that has been submitted in the following link and the feature using on-premises gateway to work with online data sources is under review, please vote it. The current workaround is to use the personal gateway to schedule refresh for your dataset.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gatew...
Thanks,
Lydia Zhang
Thanks for the pointer to the link.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
61 | |
40 | |
40 | |
28 | |
17 |