Use dataflows or datasets?

[madpimenta013]

Recently I have migrated all the data to a database, and done the ETL directly on the server, and loaded into Power BI only the query with all the transformations. For me this sped up a lot. So I decided to do this in dataflows, and load in the report the dataflows instead of the queries. I did this in the hope of getting even faster updating and loading the data in the report.

However, I am having a lot of problems, sometimes I open the PBIX file it says that the table does not exist, and then I open the dataflow and the table is there, so I have to delete all the tables and load again.

What do you think about using dataflows instead of loading the queries directly into the dataset? Do you think it's really worth it and makes it faster, or doesn't it change much?

What would you do to make loading and updating the report faster?

[ribisht17]

@madpimenta013 

Please check this video https://www.youtube.com/watch?v=Biz-s-YoKRc&pp=ygUsc2hvdWxkIHdlIHVzZSBkYXRhc2V0IG9yIGRhdGFmbG93IHBvd...

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[ray_aramburo]

Dataflows will always be faster since all the processing and ETL is previously done when they are refreshed. Instead of processing data from multiple sources, Power BI would just refer to the dataflow server. However, if you are working with just 2 single tables, then a dataflow is not worth it. On your case, I would check up the dataflow connector and ensure the dataflow refreshes properly.