Forum Discussion

eferreira's avatar
eferreira
New Member
10 years ago

Use SQL Store Procedure in Power BI

I have created a basic stored procedure without parameters in SQL Server, when I use the store procedure in Power Bi Desktop the return is ok in design but when I click on Save and Close in datasourc...
Vivs18's avatar
Vivs18
Regular Visitor
10 years ago

Anonymous I tried proposed solution but I am getting below error in Direct Query mode against Azure SQL data source.

 

Details: "EvaluateNativeQueryUnpermitted failure: the query 'DECLARE @sqlCommand varchar(1000)
SET @sqlCommand = 'dbo.uspGetSyncEventSchedulePB'
EXEC (@sqlCommand)
' isn't approved for execution."

 

I am not sure if I am missing something as datasource is Azure Sql.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Vivs18  If you note, I make reference in my solution that it only works with Import. Not when using Direct Query.

If you want to continue to use DQ, could you create a View and reference that?

  • Vivs18's avatar
    Vivs18
    Regular Visitor
    10 years ago

    Anonymous I missed import in provided solution. But I tried with the proposed solution with Import but still it resulted in same error. I am not sure if I am missing anything here.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Vivs18 It could be a limitation in Azure SQL DB... There are a bunch of differences - Reference