Forum Discussion

David0802's avatar
David0802
Frequent Visitor
2 years ago

Gateway fails with a SQL db function call

I have a PowerBI report that connects to a SQL database and pulls data from database views. When I deploy this PowerBI report, it deploys and works fine on the PowerBI service.  If I then add a dat...
Need Help
GilbertQ's avatar
GilbertQ
Super User
2 years ago

Hi David0802 

 

As far as I know it is not possible to use SQL functions via the Gateway.

  • David0802's avatar
    David0802
    Frequent Visitor
    2 years ago

    Thanks GilbertQ , I've tried to wrap this into a DirectQuery SQL submission rather than just the function, but still no luck. I think you might be right. I researched further today and can see a Microsoft link that doesn't allow Stored Procedures to be called, but not specifically ruling out Functions...which I think should still be allowed but perhaps only in Import mode. 

     

    I'll persevere, would be a good outcome if I can get working.