Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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:...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

What is your atomsvc file connecting to?  If SharePoint list or another source, can you use that connector in Power BI instead?  If not, an atomsvc file is an xml file, you perhaps you can use that connector and parse out the url, and then pass that into a Web.Contents function?

 

Pat

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Pat !

My .atomsvc is connected on a local server, i can't use the file with power BI because they tells me to put an http file. Can you tell me how to convert an .atomsvc file into a xml file ? 

I dont know how to cut the url of the .atomsvc file, here is the link when I open it in text : 

 

<?xml version="1.0" encoding="utf-8" standalone="yes"?><service xmlns:atom="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns="http://www.w3.org/2007/app"><workspace><atom:title>Suivi Non Stop</atom:title><collection href="http://smntlvdsql12/ReportServer_CRMDB?%2FALL%2FRapports%20CAMER%2FProduction%2FLocal%2FSuivi%20Non%20Stop&amp;periode=3&amp;debut=01%2F01%2F2021%2000%3A00%3A00&amp;fin=08%2F01%2F2050%2000%3A00%3A00&amp;machine=3101&amp;machine=3341&amp;machine=3342&amp;machine=3343&amp;machine=3344&amp;machine=3345&amp;machine=3346&amp;machine=3401&amp;machine=3801&amp;machine=3901&amp;machine=3902&amp;machine=4201&amp;machine=4202&amp;rs%3AParameterLanguage=&amp;rs%3ACommand=Render&amp;rs%3AFormat=ATOM&amp;rc%3AItemPath=table1"><atom:title>table1</atom:title></collection></workspace></service>

 

Can you tell me what part i must use ?

 

Thanks a lot !

Menez