Forum Discussion

WandersonReis's avatar
WandersonReis
Regular Visitor
5 years ago
Solved

Power BI Report Server cannot create the schedule refresh

When I try to create a schedule refresh, I get the message: Occurred an error, cannot find the item '/report'. This is my service user svc_powerbi. This is the roles that is associated ...
Schedule Refresh
  • WandersonReis's avatar
    WandersonReis
    5 years ago

    After reading some documents and try some experiments I got the reason about the problem. I was using DirectQuery when I connect with the database, but you can only create a schedule report if you import all the schema or table or you can create a view on the database and import this table view to visualize on Power BI Desktop, and that allows you create a schedule report on the Power BI Report Server.

WandersonReis's avatar
WandersonReis
Regular Visitor
5 years ago

After reading some documents and try some experiments I got the reason about the problem. I was using DirectQuery when I connect with the database, but you can only create a schedule report if you import all the schema or table or you can create a view on the database and import this table view to visualize on Power BI Desktop, and that allows you create a schedule report on the Power BI Report Server.