- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Report server- limiting power query and making bookmarks
Hello guys,
I need to ask if there is a way to limit access to power query a completely restric so that user coudln't manipulate with data in any way.
I still want them to be able to open the report because of creating bookmarks because as I understand it the only way users could have any kind of bookmarks is through Desktop aplication. So i want them access around 50% of Desktop aplication. The manipulation with data should be off limit and only the visualization should be accessiable.
Thanks in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not possible in Power BI RS alone... Only two ways ...
1) Move this reports to cloud Power BI Service, where it is possible
2) Use SQL Server Analysis Services for data model and live connected Power BI for visualisation, if you want keep on-premise
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for reply
If i understand it correctly with quick research SQL Server Analysis Services (SSAS) basicly seperates data modeling and visualization. And if power bi is connected to SSAS there is only option to create visuals but is it impossible to manipulate data (Create new, change or erase)
Are there any downfall because of using SSAS as middle man between Power BI and SQL?
Because for me it seams only as additional steps but without any kind of limitation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, exactly, SSAS separates model with data, and PBI report for visualisation.
There no functional or performance downfall (Power BI import mode also use internal SSAS database). On the contrary, SSAS will allow much more (what on PBIRS alone is not possible), like incremental data refresh (partitioning), large models (there no limit 1GB), and you can share single model to many reports.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not possible in Power BI RS alone... Only two ways ...
1) Move this reports to cloud Power BI Service, where it is possible
2) Use SQL Server Analysis Services for data model and live connected Power BI for visualisation, if you want keep on-premise
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am trying to find this because there is request o be able to save filters and as i founded the only way to save filters is in desktop. I don't need the personalized bookmark just be able to save them as user.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
12-12-2023 03:06 AM | |||
01-09-2023 10:23 PM | |||
07-19-2024 11:07 AM | |||
07-09-2024 12:08 PM | |||
Anonymous
| 04-07-2024 01:35 PM |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
4 | |
2 | |
2 | |
2 |