Forum Discussion

ucilengi's avatar
ucilengi
New Member
9 years ago

get data from atom file

In powerpivot, it is possible to get data using atom file (.atomsvc) by simply connectiong to the file. In the power bi desktop tool the only option is connection via odata. however, this does not wo...
Farwest's avatar
Farwest
Frequent Visitor
8 years ago

Hi All,

 

I am reviving this discussion from 2016 as I do have the same problem, is there a way to read an .atomsvc file from power Bi desktop. PowerPivot does it but when importing the data model into PowerBI, it only extract the data contained in the atom file and not the feed data.

 

Thanks

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

 For anyone else stumbling across this, if you view the raw xml you'll see the web connection Power BI can use. It will be of the form :

 

https://server/reportservername?/reportfolder/reportname

 

It will then likely include a lof parameters you can remove, and end with:

 

&rs:Format=ATOM

 

Change this to:

 

&rs:Format=CSV

 

To finally yield:

 

http://server/reportservername?/reportfolder/reportname&rs:Format=CSV

 

Head to Power BI and make a new web connection using the string above and you should be all set.