Forum Discussion
Disabling "Include in report refresh" not working
Anonymous,
" These PBIX are published in the Cloud and are scheduled to refresh themselves overnight as well as during the day."
"Include in report refresh" option only works for Power BI Desktop, it doesn't impact the refresh process in Power BI Service.
In Power BI Desktop, when you disable "Include in report refresh" option, data will not update in report view of Power BI Desktop after you click "Refresh" button in Desktop.
Regards,
Lydia
hi ToddChitt
I have tried get data from PowerBI dataflow and get this:
- Upload xlsx file to workspace as Data flow
- From Power BI desktop, import a table from Get data > Power BI Data Flows
- In Power Query Editor, uncheck "Include in report refresh" > Close & Apply
- Save and publish file to the workspace
- In the workspace (Power BI service), set up credential for the dataset, so that report can be refreshed
When I update the table in Data flow, then refresh the report, data in the report is not updated (as I expect)
It does not solve my problem. The thing I want is to refresh the table which is NOT "Include in report refresh". Because that table rarely changes, but when it does, I want to refresh it in service.
Have you looked at incremental refresh in data flow? Your other option is to put some custom code to detect change in the data source and then call a REST API to trigger a refresh.
Anonymous
Just so many complicated trick to do this. In desktop mode, we can easily refresh a single table manually. I give up with this PBI service and hope Microsoft team will do some update on this.