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:
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:
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.
Community Support Team _ Ailsa Tao