Forum Discussion

Fibos's avatar
Fibos
Frequent Visitor
2 years ago
Solved

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 repor...
"Power BI Report Server"
  • josef78's avatar
    josef78
    2 years ago

    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

Fibos's avatar
Fibos
Frequent Visitor
2 years ago

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.

  • josef78's avatar
    josef78
    Memorable Member
    2 years ago

    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.