Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
i have a dataflow updating regularly from the web (incoming CSV file i) and a dataset linked to it. Altough the update is succesful on both, i can see the new incoming data only in the dataflow. In the dataset it takes many hours (8-10) until the changes are reflected.
Any support appreciated.
Thanks a lot and regards,
Antony
Hi @Anonymous ,
While connecting Power BI Dataflow into Desktop, it is live connection mode. So, in theory, it is as fast as in Service. But in fact, we may need to wait for a few seconds or minutes. It depends on the report itself. You could reference the blog to optimize the performance of dataflow.
How to Use Dataflow to Make the Refresh of Power BI Solution FASTER!
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yingjl
thanks for the answer. I have set up my connection as described in the blog - except I-m not using a gateway but a web source.
Now i am ta 13 hours that the data have not been refreshed in the dataset. Dataflow looks good though!
I noticed that if i edit the Dataflow and save and refresh then the dataset is updated - but then it is a manual process...
Regards,
Antonis
Hi Gilbert,
thanks for the answer. Yes this makes sense - actually i have set up the connection like you suggest from the beginning.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.