Forum Discussion
Advice on Reusing a Big Table in Many Datasets
Hi everyone, what do you advise, how to reuse the same big table in many datasets, please? More specifically, I have a table with 20 million rows (4 columns), which I'm using for our custom r...
- Hi there
Just so that I understand you want to incorporate this one table into all the other datasets?
If so I am not sure how else it can be done unless you import it all into a single dataset that can then be shared across all the different reports?
Hi there
Just so that I understand you want to incorporate this one table into all the other datasets?
If so I am not sure how else it can be done unless you import it all into a single dataset that can then be shared across all the different reports?
Just so that I understand you want to incorporate this one table into all the other datasets?
If so I am not sure how else it can be done unless you import it all into a single dataset that can then be shared across all the different reports?
Hi Gilbert,
thanks for the reply and, yes, you understood correctly.
Do you know perhaps if there is much difference in performance and costs/traffic generated, for datasets to refresh daily from a Power BI dataflow (which is in an Azure Data Lake if I understand correctly) or directly from an Azure SQL Server, please?
Thank you and best regards,
Mike
- Hi there
As long as the Azure SQL Server database is in the same region there would be no costs or traffic generated. And the performance should be really fast if you have good database design and have a good query.
Dataflows do allow reuse of the same data by multiple datasets and if need be can do some of the ETL if needed on your data.