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

0

Regression - "Add to local model" now fails on Streaming Datasets

Previously working composite model with direct query on a streaming dataset and import on a dataflow is now triggering errors on usage of the streaming dataset data: 

remy_guitton_0-1675255062528.png

We get now systematic error when trying to add a streaming dataset to local model, tested with two different streaming datasets and on latest version of power bi desktop + september release to confirm it is not related to the desktop client: 

remy_guitton_1-1675255132678.png

 

Status: Delivered

Hi @remy_guitton 

Customer should not use DQ against streaming dataset hosted in workspaces . You can try this workaround :

#1. Using Azure stream analytics write streaming data to a SQL store(Outputs from Azure Stream Analytics | Microsoft Learn). Basically, we need to write realtime ingestion data to a store where we can do DQ.

#2. And create a DQ model using above datasource

#3. Build proxymodel and configure APR\CDM for realtime report refresh.

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Delivered

Hi @remy_guitton 

Customer should not use DQ against streaming dataset hosted in workspaces . You can try this workaround :

#1. Using Azure stream analytics write streaming data to a SQL store(Outputs from Azure Stream Analytics | Microsoft Learn). Basically, we need to write realtime ingestion data to a store where we can do DQ.

#2. And create a DQ model using above datasource

#3. Build proxymodel and configure APR\CDM for realtime report refresh.

 

Best Regards,
Community Support Team _ Ailsa Tao

remy_guitton
Advocate I

Hello,

 

This feature had been fully working until a couple of weeks ago.

Do you mean it was actively blocked recently, and if so could you share the underlying reason?

 

Thank you in advance for your answer, for now I do not consider the issue fixed.

 

Best Regards, 

Rémy