Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

multiple table reports from run one stored procedure

I posted original question in https://community.powerbi.com/t5/Desktop/SQL-Stored-Procedure-with-2-result-sets/td-p/1149559   But did not get any clear reply to it so I am following up now.   bas...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi  Anonymous 

Power BI will not ingest more than one table at once returned from a SP.

 

Use the filter queries inside your SP to fetch data inside Power BI.

Basically, you will have two separate queries for two tables.

 

Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Lin,

Can you please explain what you mean by: "Use the filter queries inside your SP to fetch data inside Power BI."

Thank you