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...
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