Forum Discussion
Gateway unavailable - DirectQuery to AS source not working on report
Hi samc_26 -Dataflows and Datamarts rely on cloud-based connections and have specific requirements for compatibility. The message you're seeing indicates that the DirectQuery connections you're using for Analysis Services (AS) aren't supported within the current cloud environment you're using for Dataflows or Datamarts.
You need to ensure that you're using the on-premises gateway correctly for Analysis Services (AS) connections. This may require switching from personal mode to standard mode in your gateway setup.
- To create the correct connections:
- Go to Manage Gateways in Power BI Service.
- Ensure the gateway is properly configured to support DirectQuery to AS.
- You may need to delete and re-add the data sources under Enterprise Mode Gateway instead of using personal cloud connections.
- Switch from Personal Mode to Standard Mode Gateway for AS.
- Recreate dataflows, if necessary, within the Dataflows editor.
- If you’re facing issues with the Analysis Services connection, check its credentials and ensure the gateway is set to handle DirectQuery.
Hope this inputs helps to sort the issue.
- To create the correct connections:
Hi samc_26 -Dataflows and Datamarts rely on cloud-based connections and have specific requirements for compatibility. The message you're seeing indicates that the DirectQuery connections you're using for Analysis Services (AS) aren't supported within the current cloud environment you're using for Dataflows or Datamarts.
You need to ensure that you're using the on-premises gateway correctly for Analysis Services (AS) connections. This may require switching from personal mode to standard mode in your gateway setup.
- To create the correct connections:
- Go to Manage Gateways in Power BI Service.
- Ensure the gateway is properly configured to support DirectQuery to AS.
- You may need to delete and re-add the data sources under Enterprise Mode Gateway instead of using personal cloud connections.
- Switch from Personal Mode to Standard Mode Gateway for AS.
- Recreate dataflows, if necessary, within the Dataflows editor.
- If you’re facing issues with the Analysis Services connection, check its credentials and ensure the gateway is set to handle DirectQuery.
Hope this inputs helps to sort the issue.
Hi, thank you so much for the advice, I had to delete the data sources and then add them back in and it worked! I was so happy! 🌟
However, I logged back in this morning and it's broken 😔 my company makes us change our windows passwords every so often (which I had to do this morning) and I'm wondering if that's what's broken it? I didn't change the password until I'd had the notification that the ato-refresh was broken but wondering if it broke because my old password had already timed out over the weekend? I don't think any of the scheduled refreshes have actually worked, it's only published from the desktop successfully but I need the auto-refreshes to work anyway. These are the errors I've got at present. Any help again gratefully received!