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.
This helped me this morning - thank you! Worked like a charm.
I was previously attempting a scheduled "subscribed" report from SQL Server Reporting Services" but the file path does not permit Windows File Share access to the folder. I work at a big company so access is locked down on many things, trying to bypass that, but this worked perfectly for what I needed to accomplish.
The data connection and refresh is rather slow. Compartively speaking, I could run the report, export the CSV and refresh the data in my Power BI within 5 minutes compared to the almost 15 minutes it took for the file to load - however, once I update my connections/formulas to reference the Data Feed dataset, I'll have the dashboard on an automated refresh cycle while I'm sleeping and will be able to put a few extra minutes back into each day. That's close to 20 hours a year that can be saved for me. Time to take a couple days off of work now!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?
This is gold. I've been wanting to do this for years and this is the first solution I've ever seen. Thanks for posting.
