Forum Discussion
Setting a report to auto-update based on a dataflow
I have a report which is running off a dataflow - the source for which is an SQL data warehouse my company's set up.
The issue I;ve got is - the dataflow and its scheduled refresh is definitely working. If I refresh the pbix file in the desktop app, it works, and shows the expected date for the lastest data collected after its refreshed. The data warehouse gets the data from our main server at 10PM UTC, and then the dataflow runs its refresh at 1AM.
But - The published report on the service hasn;t updated. not only that, but if I edit the report (again in the web service) clicking the refresh icon does nothing.
Any ideas on what I'm missing?
Thanks.
Hi , RichXM655
According to your description, you are connecting your dataflow in Power Bi Desktop and publish a report to Power BI Service . And the dataflow refresh works good but the report can not see the updated data , right?
By default, the connection dataflow uses import mode.That means the dataset also need to refresh so that it can show the updated data .Using Import brings the data into Power BI, and requires the dataset to be refreshed independently of the dataflow.
For this , you can refer to :
Configure and consume a dataflow - Power BI | Microsoft LearnAnd you can also refer to this to configure the dataset refresh :
Data refresh in Power BI - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi , RichXM655
According to your description, you are connecting your dataflow in Power Bi Desktop and publish a report to Power BI Service . And the dataflow refresh works good but the report can not see the updated data , right?
By default, the connection dataflow uses import mode.That means the dataset also need to refresh so that it can show the updated data .Using Import brings the data into Power BI, and requires the dataset to be refreshed independently of the dataflow.
For this , you can refer to :
Configure and consume a dataflow - Power BI | Microsoft LearnAnd you can also refer to this to configure the dataset refresh :
Data refresh in Power BI - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly