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.
I've run into an odd error where I'm pulling data from http://www.yr.no/place/Canada/Alberta/Swan_Hills/long.html. Refreshing it in the desktop works fine, and it also used to work fine with the personal gateway. I've reproduced it in two seperate environments, so I know it's not something to do with connectivity. I'd like to know if anyone else has the same problem with the personal gateway. Also, I've looked through the gateway logs and haven't been able to determine anything.
Here's my M code.
let
Source = Web.Page(Web.Contents("http://www.yr.no/place/Canada/Alberta/Swan_Hills/long.html")),
Data1 = Source{1}[Data],
#"Extracted Last Characters" = Table.TransformColumns(Data1, {{"Date", each Text.End(Text.From(_, "en-CA"), 10), type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Extracted Last Characters",{{"Date", "ImportedDate"}})
in
#"Renamed Columns"
Here's my actual PBIX fle.
http://www.performancedataanalytics.com/public/weather%20test.pbix
Ideas?
Jeremie
Solved! Go to Solution.
Hi @Jeremie,
This is a known issue, and PG team are working on the fix. You can check status of this issue from Support site:
Best Regards,
QiuyunYu
Hi @Jeremie,
This is a known issue, and PG team are working on the fix. You can check status of this issue from Support site:
Best Regards,
QiuyunYu
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.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |