Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
I have connected to synapse sql dedicated pool database(direct quiery) .But i am getting this error while refresh the report in service,but desktop level it is refreshing fine. I have power BI pro (trail) lisence.
can any budy assist on this.
Hi Team,
My issuie is still going on i have few questions and written in below
>> for synaspce dedicated pool it is cloud right .so currenty i dont have any gateways configured. if it riqured for gateways i will be confgire.
>> with out gateways is it not possible to refresh with direct query ?
please ansr me above my questions.
Thanks
Hi @Anonymous ,
Firstly, gateway is based on the data source not the way of get data.
Secondly, I didn't find this "synaspce dedicated pool" as a data source in Power BI. What connector you are using?
https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources#data-sources-s
Best Regards,
Jay
Hi Team,
Please find below screen shots
The above data soruce I am using in Power BI desktop and publishing into service .
there I am getting error once i refresh this report(direct query)
Thanks
Hi @Anonymous ,
Please check whether the gateway is working properly and whether the data source is connected.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues.
If it is not there, then you could post it.
Best Regards,
Jay
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 32 | |
| 18 | |
| 14 |