Data Flow or Data Set

[echerian]

Hi,

We have requirement to expose data from one database table in Power BI Service. As the users are not given access to database, the option availabe is to publish that data as a dataflow or Power BI Datatset. What would be the best option for this scenario ? Should it be a dataflow or a dataset.

Background : I prefer to do this in dataflow. By my experince with dataflow is not great. So I want to check with community how to handle this scenario.

Thanks

[ibarrau]

Hi. Considering you just can't use database, because the best idea would be letting user only view that single table of the DB, the dataflow is the best alternative. Dataflow will let you import a single table for many users. You own any base transformation and they can filter or change that later. Datasets won't let you do all that. Users will need composite model everytime they use the table as direct query. That can be tricky and reduce performance.

Dataflows might not have the best performance when processing their transformations, but once it's loaded, it's great for users.

I hope that helps,