Forum Discussion
Open .atomsvc files with Power BI
Advocate IThis is what worked for me using Power Query to pull into Power BI:
1. Download your .atomsvc file. Open it in notepad and find the part that says href=http://<some_long_url>
2. Copy the url out to a new notepad without the href= and without the quotes "
3. Replace the following:
& with &
note the ; is part of what is being replaced.
Replace %3A with :
Replace Format=ATOM with Format=CSV
In powerquery, create a new query and select Web.
Use the new url you created.
Select type of authentication, if needed.
Transform your data as normal.
Hope this helps someone.
Thank you very much for sharing this, it helped me a lot!
Do you know what the impact is from using this method on time formatting? Currently I have the problem that my time formatting is messed up.
When I read the data via ATOM format, I get for example 01/01/2023 14:50:23. But when I transform it to CSV (with the method mentioned above), I get as output 01/01/2023 02:50:23. Without any AM or PM information. Do you know how to solve this?