Forum Discussion
Dataset Access from PowerBI Desktop
Hi Luis92,
In Power BI, when you connect to a published dataset, the default behavior is a Live Connection. As you've discovered, a Live Connection is "Read-Only" for the model schema - you can't add tables or transform data.
To transform data, you have to switch to a Composite Model, which creates a new "chained" dataset or second dataset as you call it.
Solution:
If you want to give them the ability to "transform" without touching the database, Dataflows are your best friend.
-
Instead of a DirectQuery dataset, build a Dataflow that connects to your PostgreSQL DB via the Gateway.
-
Your contributors connect to this Dataflow in Import Mode.
-
They can transform the data to their heart's content in Power BI Desktop. They never need the database password because the Gateway handles the "handshake," and they only publish one primary dataset.
Dataflows are ideal in your scenario. Let me know how it goes!
-
Hi Luis92,
In Power BI, when you connect to a published dataset, the default behavior is a Live Connection. As you've discovered, a Live Connection is "Read-Only" for the model schema - you can't add tables or transform data.
To transform data, you have to switch to a Composite Model, which creates a new "chained" dataset or second dataset as you call it.
Solution:
If you want to give them the ability to "transform" without touching the database, Dataflows are your best friend.
-
Instead of a DirectQuery dataset, build a Dataflow that connects to your PostgreSQL DB via the Gateway.
-
Your contributors connect to this Dataflow in Import Mode.
-
They can transform the data to their heart's content in Power BI Desktop. They never need the database password because the Gateway handles the "handshake," and they only publish one primary dataset.
Dataflows are ideal in your scenario. Let me know how it goes!