SQL Store Procedure Connection

[Pooja_Dasani_98]

I am trying to make a connection with the SQL server store procedure in Power BI. I am using import mode and writing the following statement in the SQL statement dailog box - "exec czrq_Inbox_Items_datamart". 

The following error poops up - This native database query isn't currently supported."

Any help on this will be greatly appreciated.

[v-pagayam-msft]

Hi @Pooja_Dasani_98 ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @Pooja_Dasani_98 ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.

[v-pagayam-msft]

Hi @Pooja_Dasani_98 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your answer and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.

Regards,
Pallavi.

[Pooja_Dasani_98]

Creating a view won't work for my requirement. I want to connect to the store procedure directly. 

[Deku]

There is a solution on this thread you could try

[Deku]

Please see this related forum post 

Create a view that call the stores proc