Forum Discussion

ptacquet's avatar
ptacquet
Frequent Visitor
4 years ago

deploy a dataset based on dataflow connector

Hi,

 

I have datflows based on sql server.

I  use those dataflows in datasets, that i deploy with pipelines.

All the steck is used !

 

It's ok when i use powerbi dataflow connector.

But i have performance issues with a big table (195M rows).

I tried to configure incremental refresh. 

It didn't work at all.

https://blog.crossjoin.co.uk/2021/08/22/how-query-folding-and-the-new-power-bi-dataflows-connector-can-help-dataset-refresh-performance/#comment-121616 

I noticed that it's now prefered to use the new Dataflow connector that allows query folding.

 

When i publish on my dev stage, a  generic dataflow source appears on lineage but without a link to the data flow table used.

Et when i depoyed on test and refresh the dataset, there's a problem. It's not data from tests stage but dev stage....