Alright. Now I'm getting the idea. You don't own the source, it's a web income similar to an API. You just have a single url. When the data is not there it fail and doesn't return anything.
The best approach for getting data from API or URL would be building a warehouse or lakehouse to build a history data. Just for you to keep in mind.
For now, you can use power query code to capture failures. Depending in which step the error is thrown, the solution can change.
- Error at web content: you can handle it with parameters of the method if you know the code error of the request. For example:
= Csv.Document(
Web.Contents("https://raw.githubusercontent.com/ibarrau/PowerBi-code/refs/heads/master/DatosPrueba/ProductCategoryaa.csv"
, [ManualStatusHandling={404, 400}]
) ,[Delimiter=";", Columns=2, Encoding=65001, QuoteStyle=QuoteStyle.None]
)
That example will return a table with a two column (like csv specify) with the error when the webcontent fails for 404 or 400.
Then as the otherwise result you can build an empty tables with the same column names of a traditional result with: https://learn.microsoft.com/en-us/powerquery-m/sharptable
try [Code that throw error] otherwise #table({"Column1", "Column2"})
That should handle the error to prevent the fail when refreshing and just return an empty table.
I hope that make sense
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Happy to help!
LaDataWeb Blog
