Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have created a push dataset for real time data straming in Power BI Service
Using the how to guides Im creating Powershell to run it.
However Im getting errors so if anyone knows Powershell and can see what Im doing wrong....
Its when I create the query variable
$query = '
CREATE @TableName Varchar(200) = ('dim.Realtimedatatestingcustomer');
DECLARE @MaxUpdateDate DateTime = (SELECT MAX(UpdateDate) FROM [dim].[RealTimedatatestingcustomerDE]);
DECLARE @OldUpdateDate DateTime = (SELECT ISNULL([UpdateDate],0) FROM audit.RealTimeDataAudit WHERE TableName = @TableName);
UPDATE audit.RealTimeDataAudit
SET [UpdateDate] = @MaxUpdateDate
WHERE TableName = @TableName;
SELECT [CustKey], [Name], [UpdateDate] FROM [dim].[RealTimedatatestingcustomerDE]
WHERE [UpdateDate] = @MaxUpdateDate; '
Essentially it seems to be the where part thats causing problems
At line:20 char:38
+ ... CREATE @TableName Varchar(200) = ('dim.Realtimedatatestingcustomer');
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Unexpected token 'dim.Realtimedatatestingcustomer');
Ive tried adding it without () and I got the same error
I tried adding it "dim.Realtimedatatestingcustomer" but that gives you a SQL error
Basically Im not sure how to add a Where = '' in the Powershell
Any advice would be gratefully recieved
Solved! Go to Solution.
Hi @DebbieE ,
try this.
$query = @'
CREATE @TableName Varchar(200) = ('dim.Realtimedatatestingcustomer');
DECLARE @MaxUpdateDate DateTime = (SELECT MAX(UpdateDate) FROM [dim].[RealTimedatatestingcustomerDE]);
DECLARE @OldUpdateDate DateTime = (SELECT ISNULL([UpdateDate],0) FROM audit.RealTimeDataAudit WHERE TableName = @TableName);
UPDATE audit.RealTimeDataAudit
SET [UpdateDate] = @MaxUpdateDate
WHERE TableName = @TableName;
SELECT [CustKey], [Name], [UpdateDate] FROM [dim].[RealTimedatatestingcustomerDE]
WHERE [UpdateDate] = @MaxUpdateDate; '@
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi @DebbieE ,
try this.
$query = @'
CREATE @TableName Varchar(200) = ('dim.Realtimedatatestingcustomer');
DECLARE @MaxUpdateDate DateTime = (SELECT MAX(UpdateDate) FROM [dim].[RealTimedatatestingcustomerDE]);
DECLARE @OldUpdateDate DateTime = (SELECT ISNULL([UpdateDate],0) FROM audit.RealTimeDataAudit WHERE TableName = @TableName);
UPDATE audit.RealTimeDataAudit
SET [UpdateDate] = @MaxUpdateDate
WHERE TableName = @TableName;
SELECT [CustKey], [Name], [UpdateDate] FROM [dim].[RealTimedatatestingcustomerDE]
WHERE [UpdateDate] = @MaxUpdateDate; '@
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials