Forum Discussion

Coffeehouse45's avatar
Coffeehouse45
Frequent Visitor
1 year ago
Solved

Create pbix file for User -- no access to db server

Hey All, We are using Power BI report Server (jan 2025). I would like to avoid giving a user read access to our SQL Server. I'd rather create a .pbix file using the tables that they need, then set t...
"Power BI Report Server "
  • lbendlin's avatar
    lbendlin
    1 year ago
    then set the file to refresh once per day (overnight).

    There is no easy way to do that. I'd not want to suggest Power Automate Desktop as it is not reliable enough.

     

    You could concoct a solution that includes a scheduled refresh of the semantic model and then a powershell (or similar) script to download the pbix to a shared folder. 

     

    If you don't want your users to have access to the data, don't show them the data. Better yet, don't have the data yourself.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
then set the file to refresh once per day (overnight).

There is no easy way to do that. I'd not want to suggest Power Automate Desktop as it is not reliable enough.

 

You could concoct a solution that includes a scheduled refresh of the semantic model and then a powershell (or similar) script to download the pbix to a shared folder. 

 

If you don't want your users to have access to the data, don't show them the data. Better yet, don't have the data yourself.