Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
liey87
Frequent Visitor

Dataset is not created from azure stream analytics output sink

Guys,

 

I've been through this for some times. Really bugging me now. Today I have create a new version of simple data sending to IoT-Hub. Then stream analytics will stream incoming data from IoT-Hub as Input and sink into PowerBi Pro Account as Output. On the Query, I have made simple

 

SELECT
*
INTO
[outgoing]
FROM
[incoming]

 

But turns out, no dataset were created on PowerBi "Dataset". This been happening for 3 projects where no dataset has been auto create at the time, stream analytics process it. Does anyone have the idea? Direct streaming dataset using API is not a problem but the architecture is must be through Azure services and this is the problem I'm facing, no new dataset were created after process on Stream Analytics. Need some clarification and advice

1 ACCEPTED SOLUTION
liey87
Frequent Visitor

Hi @v-haibl-msft

 

Yeah. I found that the dataset is exist on Streaming Dataset part, not like previous which in datasets panel.

 

So which mean, its can be Real-Time Streaming. This was great. Thanks

View solution in original post

7 REPLIES 7
webermat
New Member

I'm facing the same issue. Does anyone has a solution for that?

webermat
New Member

I do have the same problem. When I make a connection with stream analytics in azure portal, the dataset is not going to be created in the power bi. Is there a solution?

webermat
New Member

I do have the same problem. When I create a connection in stream analytics to power bi, it's not creating a dataset in power bi. Does anyone has a solution for that?

 

 

liey87
Frequent Visitor

Hi @v-haibl-msft

 

Yeah. I found that the dataset is exist on Streaming Dataset part, not like previous which in datasets panel.

 

So which mean, its can be Real-Time Streaming. This was great. Thanks

Anonymous
Not applicable

@liey87, Where is the streaming dataset part, the place where your dataset was sitting instead of my workspace-->dataset ? Can you please send a snapshot?

Hello everyone,

I am facing a similar issue. My query is quite simple:
SELECT
*
INTO
[OutputJob]
FROM
[InputJob]

Input Job is receiving input data from Event Hub and is tested successfully.

Output Job is pointed to Power BI, creating a new DataSet and a new Table. But, I do not see the new DataSet and the Table in the Power BI under my selected Work Space. Please provide me some inputs.

Also, as per the link:
http://community.powerbi.com/t5/Integrations-with-Files-and/Dataset-is-not-created-from-azure-stream...

I have mailed my Azure Subscription ID and the region i want to see the data in, to ASAtoPBIStreaming@microsoft.com
But, i haven't heard back anything from them as well.

Thanks in advance!

v-haibl-msft
Employee
Employee

@liey87

 

Are you using the feature introduced in this blog? It seems that it is available for private preview and you need to email ASAtoPBIStreaming@microsoft.com with your Azure subscription ID and the region you’d like to enable for private preview.

And there is a step to step guide here and the dataset is created in the end.

 

Best Regards,

Herbert

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors