Forum Discussion
Solved
Filetring my table before importing in PowerBi
Hi, Sorry for my english, it's not my main language. I would like to import my data in powerBi but filtering it with some id. Let's take this example. I have db with some companies(table 1). Eca...
This man did your job : https://stackoverflow.com/questions/46715097/get-only-the-data-i-want-from-a-db-but-keep-structure
Thanks.
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.