Dataflow creation on SQL database - best practices

[vadlamudibi]

Dear Experts,

We have a requirement to create Dataflows on SQL database.

below is the scenario

2 data bases and around 30 tables in each database.

what is the best approach to create dataflow considering the performances, refresh schedules and best design.

thanks in advance.

Best

vad

[v-xicai]

Hi  @vadlamudibi ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @vadlamudibi ,

Please refer to the link How to Use Dataflow to Make the Refresh of Power BI Solution FASTER!

Dataflows are only supported using Enterprise Gateways. To use an on-premises data source in a dataflow, any user creating the dataflow must have an Enterprise Gateway installed and configured. The user creating the dataflow also must be the Enterprise Gateway's administrator in order to use that gateway for a dataflow. To learn more about Enterprise Gateways, see On-premises data gateway.

You can also use incremental refresh for dataflow, see more detail:https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh.

What's more, if you have a Premium license, you will have access to more or fewer functionalities within Dataflow, see more: https://blogs.solidq.com/en/businessanalytics/power-bi-dataflows-how-does-the-new-tool-work/.

Note: For the blogs above, please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly