Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Report changes to Import Query mode when I publish a Direct Query report in Power BI

Not fully sure what's happening here. But when I publish the report (see image - for direct query it should be schedule cache refresh). These are the possible reasons I think and I would appreciate ...
Need Help
  • cyclist007's avatar
    cyclist007
    4 years ago

    I have a bunch of direct query reports and it shows me as well. It does not mean that report is converted to import mode. Rather if you can expand that "Schedule Refresh" if tells the refresh is for a dashboard tile (the dashboard tile might be a pinned report visual). So the refresh is more for a dashboard tile (feeding off the report), not the published report. 

cyclist007's avatar
cyclist007
Icon for Responsive Resident rankResponsive Resident
4 years ago

DirectQuery is available for Pro (so that is not a reason)

 

Direct Query basically means when the viewer opens the report, the report will fetch the data at that time (directly query the data when report is opened). Hence there is no need to schedule refresh the data.

If you open the report today at 4pm ... you will see the report refreshed as of 4pm.  If the next user opens the report at 5.05pm they will see data as of 5.05pm. The report does not store the data (hence there is no refresh), the data is pulled (queried) when the report is opened (and will then not update - if the report just remains open ... unless you re-open the report).

Scheduled refresh is for Import mode - when you pull the data into Power BI report, and henced the pulled data needs to be refreshed updated at certain intervals (max 8 times a day).

Hope this clairifies.