Forum Discussion

narchans4u's avatar
narchans4u
Frequent Visitor
8 years ago
Solved

Call SP that returns multiple datasets from power BI (import mode - adv option - custom SQL)

Hi,   I want to import multiple data sets (tables) with some initial conditions. for example - my SP returns 2 tables based on some condition:   create or alter proc sp_import_table as begin ...
Need Help
  • narchans4u's avatar
    narchans4u
    8 years ago

    Ok - thanks for your response.

prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
8 years ago

Hi narchans4u,

 

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.

 

Prateek Raina

 

 

narchans4u's avatar
narchans4u
Frequent Visitor
8 years ago

Ok - thanks for your response.