Forum Discussion
Open .atomsvc files with Power BI
Hello guys, I have some problems with my power BI, I can't connect my datas. I have some .atomsvc files, when i want to connect 1 table I click on "Flux ODATA" and put the URL of the file ( like C:...
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 is gold. I've been wanting to do this for years and this is the first solution I've ever seen. Thanks for posting.