Forum Discussion
Data Flow or Data Set
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 Pow...
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,