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.

Icey's avatar
Icey
Community Support
5 years ago

Hi WandersonReis ,

 

I ran into the same issue. After changing the account from "Virtual Service Account" to "Domain account", the error disappeared. But I don't know the reason. Need to study more.

Reference: 

sql server - SSRS 2017 - Client found response content type of '', but expected 'text/xml' - Database Administrators Stack Exchange

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.