Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have created a report that's connected with SQL Server live (Direct Query).
However, after publish to powerbi services it stoped working as Direct Query.
Could you please help me?
Any help would be appreciated.
Thanks,
Irfan
Solved! Go to Solution.
I'm not familiar with how Google Cloud works, but I suspect that you need a gateway for Power BI to connect. Have you set that up?
Hi, I have setup it and working fine.
thank you
Hi @irfanelevated,
depending on where the SQL Server is located (on-premises or in the cloud), you might need to set up a gateway connection.
Hi Nicky, Thanks a lot for reply.
SQL server is hosted on Google Cloud.
Direct query working fine at desktop, having issue only at PowerBI Services.
I'm not familiar with how Google Cloud works, but I suspect that you need a gateway for Power BI to connect. Have you set that up?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.