Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello All
We have this query:
let
Source = Json.Document(Web.Contents("https://api.binance.com/api/v1/ticker/allPrices")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.List),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"symbol", "price"}, {"Column1.symbol", "Column1.price"}),
#"Expanded Column2" = Table.ExpandListColumn(#"Expanded Column1", "Column2"),
#"Removed Columns" = Table.RemoveColumns(#"Expanded Column2",{"Column2"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Column1.symbol", "Symbol"}, {"Column1.price", "Price"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Price", type number}})
in
#"Changed Type"
And have the connection to refresh every 1 min. The server fails from time to time and a popup appears:
We want to disable this popup (and every other one thay might appear), as it blocks the normal functioning of the worksheet till OK is clicked.
Tried with VBA but nothing works.
How can we stop it from showing?
Like: if error, do nothing.
Solved! Go to Solution.
@NicoPer,
How do you refresh the connection in Power Query? Do you get same error message in Power BI Desktop?
About Power Query issues, you can post questions in Power Query forum to get dedicated support.
Regards,
Lydia
@NicoPer,
How do you refresh the connection in Power Query? Do you get same error message in Power BI Desktop?
About Power Query issues, you can post questions in Power Query forum to get dedicated support.
Regards,
Lydia
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!