Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Can "Viewer" access users manually refresh semantic models in a PBI Service workspace?

Title is pretty self-explanatory. We built out a report (PBI service) with the intent of having users refresh its semantic model manually whenever the ingested dataset changes (self-serviced by users...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 

By default to refresh a dataset in the service a user must take over the Ownership of it. This is not possible for Users in plural and with Workspace Role Viewer. 

Other option is to use Power automate but this is a paid service.

The best option in your described affair is to set a Direct Query connection on your model, that way the report is refreshed whenever a user act on it.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Back-end data used by our semantic model comes from an on-prem CSV. Is there any way to configure a Direct Query connection for a CSV datasource, or does it have to be a database?