Stream Analytics Job Failed - unable to find assembly

Abed ElRahman Ayoub 1

I have configured the job and tested the whole things, where the input is working, query is collecting data, and output connection is working correctly.
but when it comes to starting the job an error occur with the following warning.
I'm trying to stream data from IoTHub to Power BI
where the Power BI account is different than my Azure Account and everything is working properly but when starting the job it fails.

Stream Analytics job has validation errors: Unable to find assembly 'Microsoft.EventProcessing.SteamR.Sql, Version=1.2.0.0, Culture=neutral, PublicKeyToken=<MyTokenKeyMentionedHere>

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-10-21T22:19:37.913+00:00

Hello @kaushik maji ,

Thanks for the ask and also using the Microsoft Q&A.
I did tried to repro this and it works fine when I tried to connect to PBI with the Azure account . Can you please test that on your side also ?
When you say that the "Power BI account is different than my Azure Account " can you please elaborate more on that please ?

Thanks Himanshu
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-10-26T19:29:58.36+00:00

Hello ,

We have not heard back from you on this and was just following up ,if the issue is resolved .
In case if you have a resolution we request you to share that with the community .

Thanks
Himanshu
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-11-02T22:29:51.577+00:00

Hello ,

We have not heard back from you on this and was just following up again ,if the issue is resolved .
In case if you have a resolution we request you to share that with the community .

Thanks
Himanshu
Shubhankar Jadhav 1 Reputation point

2020-11-03T06:52:52.997+00:00

Even i am getting same error while trying out IotHub tutorial

"The streaming job failed: Unable to find assembly 'Microsoft.EventProcessing.SteamR.Sql, Version=1.2.0.0, Culture=neutral, PublicKeyToken=<MyTokenKeyMentionedHere>"

have set-up both input and output job topology and test connection is good but when i run query it throws the above error

Have authorized PowerBi account
Igor Lima 1 Reputation point

2020-11-04T20:40:34.06+00:00

I also have the same problem and I couldn't find the reason why this happens, I'm following the 'Visualize real-time sensor data from Azure IoT Hub using Power BI' tutorial and this error appears when I run my Stream Analytics job
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-11-05T21:22:40.833+00:00

Hello @Igor Lima

We are sorry for the error which you are facing . We have reached out to the internal team to get help on this . CYou will update you this once we hear back from them .

Thanks
Himanshu
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-11-10T21:19:00.87+00:00

Hello @Igor Lima ,@kaushik maji ,@Abed ElRahman Ayoub ,

Just got an update from the team and at this time the team is working to roll out a fix for this . As per the team the error is only encounter when the query has some issue , they guidance is to check the query iy in query test ( on the portal ) or vs code to see what kind of syntax error it has .

I will keep the thread updated once I hear back from the team .

Thanks
Himanshu
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-11-24T17:46:16.25+00:00

Hello ,

Just heared back from the product group and they have confimred that the fix is deployed . if you are still facing the issue please let us know on this thread .

Thanks
Himanshu .
nidhi agarwal 16 Reputation points

2021-06-17T17:51:20.58+00:00

I am unable to create Power BI output on my stream analytics job. After providing Authorization from my power BI account I am not getting a workspace. Save button is also disable.
nidhi agarwal 16 Reputation points

2021-06-17T17:51:28.843+00:00

I am unable to create Power BI output on my stream analytics job. After providing Authorization from my power BI account I am not getting a workspace. Save button is also disable.