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
Thank you ToddChitt
I consider this is a shortage of Power BI service. We obviously have demands to do so but PBI service just cannot serve that. The way I am doing now is refresh it manually in desktop version and re-deploy it as you said and it's not convenient. That's why I'm here to ask for another way.
For DATAFLOW way, I have try creating but it is apparently not an easy way.
So seemingly I have no choice sticking with re-deploy way and wait for next update of PBI service.
Hello Anonymous What did you mean by "For DATAFLOW way, I have try creating but it is apparently not an easy way."?
What is the data source type you are trying to make into a Dataflow? SQL? Excel? CSV? Something else? What have you tried and what are your pain points?
It's just complicated and I have read some articles in MS but still don't know how to use, what to do. I have REF (reference) table which is not usually refresh. I have done the report in the traditional way, import everything and create in desktop version and deploy to service.
Now I've done creating my REF in dataflow (import a table from xlsx file). Then I don't know how to use it, how to link it to my report.
Consuming Dataflow inside a Power BI report is pretty straight forward. Click the Get Data and select "Power BI dataflows". Assuming you are logged in to Power BI Desktop with the same credentials that has access to the Workspace and Dataflow, it will ask you to pick a Workspace and Dataflow, and from there, the actual dataset.
From this point on it is just like any other data source with one key exception/benefit for your case: When you set up Scheduled Refresh for the model in Power BI Service, queries sourced from Dataflows are not listed. You don't have to worry about them. They can have their own refresh schedule defined.
Hope that helps.
Hi ToddChitt
I tried getting data from data flow, but there should be a mistake that table is empty. Could you check and suggest where should I miss?
My table in dataflow in PBI service:
But when I get data from PBI desktop, it says the table is empty
Thanks
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.