Forum Discussion
Open .atomsvc files with Power BI
This 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!