Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Query Regarding PBI Dataflows

Hi All, As I am delaing with large datasets, after reserach I found that the PBI Dataflows is best suitable option for same. I have designed a simple dataflow with defing bew tables form Oracls dat...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Direct Query against dataflows is a sham.  As Microsoft explained at MBAS what really happens is that they put an Azure SQL database in between the dataflows and the datasets, and then do the direct query against that database.  This completely defeats the idea of a dataflow (which is similar to csv or parquet blob storage)

 

1. Standard practice is to do transforms as high upstream as possible, but not higher! Every transform tampers with the original data and has the potential to destroy information.

2. that is automatic

3. Don't use Direct Query.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your reply but then idea of Dataflows is not useful

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    They are useful for storing large amounts of tabular-ish data that you can then ingest quickly in import mode. They can also act as a buffer between a very slow source system and your developer experience.