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.
This dataset is retrieving the data from a csv file in a Sharepoint document folder.
Ocasionally, the file is missing, and the dataset refresh fails in Power BI service fails.
This is the 1st step of the query:
= try Csv.Document(Web.Contents("https://xxx.sharepoint.com/sites/xxx/PowerBI.csv"),[Delimiter=";", Columns=7, Encoding=1252, quoteStyle=QuoteStyle.None]) otherwise #table({"ID"},{})
Is there a way to prevent this error happening and allow the dataset to refresh?
Wow what a great idea 💡
If I have an unreliable source, then I use a Dataflow to grab the data from that source.
Source > Dataflow > Dataset
If the Dataflow fails, it doesn't impact the Dataset refresh as the Dataflow just reverts back to the last successful load.
In fact, I utilize Dataflows nearly entirely for the fact that independent Dataflow failures do not derail an entire Dataset.
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.