Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
I am getting problem with scheduled refresh while using csv files .
can anyone guide me to get solution .
Solved! Go to Solution.
Hi, @Mounika_10
According to your case description, you want to configure scheduled refresh for the dataset of csv as the data source, for this case the data source is connected using Import mode, if you are connected to the local data source, you need to install the gateway to configure the data source credentials first:
Add or remove a gateway data source - Power BI | Microsoft Learn
If you are connected to a CSV data source on Cloud Drive, such as OneDrive or SharePoint, you can directly enter credentials on the service to connect to the successful data source and unlock the scheduled refresh of the dataset, you can refer to this document for details:
Configure scheduled refresh - Power BI | Microsoft Learn
Thank 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
Hi, @Mounika_10
According to your case description, you want to configure scheduled refresh for the dataset of csv as the data source, for this case the data source is connected using Import mode, if you are connected to the local data source, you need to install the gateway to configure the data source credentials first:
Add or remove a gateway data source - Power BI | Microsoft Learn
If you are connected to a CSV data source on Cloud Drive, such as OneDrive or SharePoint, you can directly enter credentials on the service to connect to the successful data source and unlock the scheduled refresh of the dataset, you can refer to this document for details:
Configure scheduled refresh - Power BI | Microsoft Learn
Thank 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
Hi @Mounika_10 ,
Please let me know where is the .csv file located.
You can follow this link if the .csv file is located in SharePoint or Onedrive
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-csv-file-onedrive
You cannot schedule refresh on a dataset created from a comma delimited file .However, when the file is on OneDrive, or SharePoint Online, Power BI will synchronize any changes to the file with the dataset automatically about every hour.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Proud to be a Super User!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.