RLS on a Push API Dataset

[marco6]

I can't find the button to access "Security" (RLS) on a Push API Dataset. Besides, I read that everything has been moved to PBI Desktop. Can anyone give me a clue?

I hope Push API is capable of doing RLS, as if it wasn't, it would be a MAJOR (and IMHO technically unjustified) limitation on this feature.

Thank you!

[Eric_Zhang · Accepted solution]

---

@marco6 wrote:

---

Eric_Zhang wrote:

I think you're dealing with the data source in a programing way

---

You are right! We decided to use ETL computation + REST API because we need data to be as much real-time as possible. Besides, if I'm not mistaking, normal datasets have a 8-times/day update limit (please, correct me if I'm wrong!) - and that is not even nearly acceptable.

We also need to restrict some users to see parts of data. If you can point us to the right direction, that would be really appreciated!

Thank you,

Marco Manino

---

Is there any listed data source that supports directquery on your side?  Your ETL feeds the data source, use directquery and you don't worry about refresh.

[Eric_Zhang]

---

@marco6 wrote:

I can't find the button to access "Security" (RLS) on a Push API Dataset. Besides, I read that everything has been moved to PBI Desktop. Can anyone give me a clue?

I hope Push API is capable of doing RLS, as if it wasn't, it would be a MAJOR (and IMHO technically unjustified) limitation on this feature.

Thank you!

---

@marco6

There's no RLS for the dataset created in REST API. You can submit your idea at Power BI Ideas and vote it up.

Could you clarify what is the exact scenario? As you're using REST API to push data, so I think you're dealing with the data source in a programing way, maybe you could save  the data in some files or database, and connect to the files/db in Power BI Desktop and set RLS to bypass the limitation. And update/refresh the files/db in a certain interval.

[marco6]

---

@Eric_Zhang wrote:

I think you're dealing with the data source in a programing way

---

You are right! We decided to use ETL computation + REST API because we need data to be as much real-time as possible. Besides, if I'm not mistaking, normal datasets have a 8-times/day update limit (please, correct me if I'm wrong!) - and that is not even nearly acceptable.

We also need to restrict some users to see parts of data. If you can point us to the right direction, that would be really appreciated!

Thank you,

Marco Manino

[Eric_Zhang · Accepted solution]

---

@marco6 wrote:

---

Eric_Zhang wrote:

I think you're dealing with the data source in a programing way

---

You are right! We decided to use ETL computation + REST API because we need data to be as much real-time as possible. Besides, if I'm not mistaking, normal datasets have a 8-times/day update limit (please, correct me if I'm wrong!) - and that is not even nearly acceptable.

We also need to restrict some users to see parts of data. If you can point us to the right direction, that would be really appreciated!

Thank you,

Marco Manino

---

Is there any listed data source that supports directquery on your side?  Your ETL feeds the data source, use directquery and you don't worry about refresh.

[marco6]

Uhm... I don't think my client have any of those... Besides this kind of solution needs major changes in the way things are done. It also needs PowerBI to be able to reach the database machine - meaning that we need to step out of the client's intranet... Am I right?

Is this the only way? If that's the case we will propose to the client.

Thank you for your support,

Marco Manino

[Eric_Zhang · Accepted solution]

---

@marco6 wrote:

Uhm... I don't think my client have any of those... Besides this kind of solution needs major changes in the way things are done. It also needs PowerBI to be able to reach the database machine - meaning that we need to step out of the client's intranet... Am I right?

Is this the only way? If that's the case we will propose to the client.

Thank you for your support,

Marco Manino

---

That shall be the only way. If all those datasource are not available, another workaround I can think of is to push data via API and create different datasets in different Power BI group. Do the data filter when before pushing data in your code, push indivisual data to indivisual groups and add members to the groups accordingly. But you'll have to create the same report in each group and there's no any API to create report in code, so if the groups number is more than, like 10, it will be hard to maintain them.

[marco6]

Our client did not accept the effort needed to implement those changes, however, I'm going to mark this as answered as the soluzion proposed would have made possible to fulfill all the requirements.

Thank you for your support!

Marco