Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Does anyone know of a start to finish tutorial for creating an Azure app with authentication that includes Power BI Embedded (using DirectQuery SQL server) and row-level security? I've found a few bits and pieces but nothing complete.
Thanks!
Solved! Go to Solution.
@gattoun wrote:
Does anyone know of a start to finish tutorial for creating an Azure app with authentication that includes Power BI Embedded (using DirectQuery SQL server) and row-level security? I've found a few bits and pieces but nothing complete.
Thanks!
Power BI Embedded is being deprecated and doesn't support direct query to the sources other than Azure SQL database/datawarehouse. There's a good demo which shows how you can build a Power BI Embedded site.
If direct query mode is still preferred, then let's start with an Azure SQL database.
As I mentioned that PBI Embedded is being deprecated, the new replacement is Embedding with non-Power BI users. It is supporting direct query to SQL Server. The steps are a little different.
@gattoun wrote:
Does anyone know of a start to finish tutorial for creating an Azure app with authentication that includes Power BI Embedded (using DirectQuery SQL server) and row-level security? I've found a few bits and pieces but nothing complete.
Thanks!
Power BI Embedded is being deprecated and doesn't support direct query to the sources other than Azure SQL database/datawarehouse. There's a good demo which shows how you can build a Power BI Embedded site.
If direct query mode is still preferred, then let's start with an Azure SQL database.
As I mentioned that PBI Embedded is being deprecated, the new replacement is Embedding with non-Power BI users. It is supporting direct query to SQL Server. The steps are a little different.
Hi Eric,
I hate to hi-jack this question, but this scenario is very similiar to ours. The primary difference is we are reporting off of a MySQL database and obviously not using DirectQuery, since it isn't supported.
I have got the APP OWNS DATA project to work for us, but wanted to add RLS. I didn't see a way to add the username and role to the token as described here, because as far as I can see, PowerBIToken is not referenced in the APP OWNS DATA sample.
Am I understanding you correctly, that even in my scenario, RLS cannot be implemented in the APP OWNS DATA sample?
thank you!
David
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |