Forum Discussion
Filetring my table before importing in PowerBi
This man did your job : https://stackoverflow.com/questions/46715097/get-only-the-data-i-want-from-a-db-but-keep-structure
Thanks.
Hum i thought about that ... But as i have 30 tables it will be a pain. I was wondering if there is an other option as an "on cascade" but for a select :/
Anyway, thank you very much for your help
Hi tried some stuff like that but PowerBi insert only the first request ...
DECLARE @monID INT;
SET @monID =xxxxx;
select * from APN_Insertion_Order where ID_Insertion_Order=@monID;
select * from APN_Campaign where ID_Insertion_Order=@monID;
SELECT *
FROM APN_Creatives
WHERE EXISTS
(SELECT *
FROM APN_Campaign
WHERE APN_Creatives.ID_Campaign = APN_Campaign.ID_Campaign and APN_Campaign.ID_Insertion_Order=@monID)
This man did your job : https://stackoverflow.com/questions/46715097/get-only-the-data-i-want-from-a-db-but-keep-structure
Thanks.