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...
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi ucilengi,

 

When the atom file is written to the URL, can you get the data which it's point to in PowerPivot? If it can be achieved, please try to import this Excel workbook into the Power BI Desktop.

 

Best Regards,

Qiuyun Yu

  • ucilengi's avatar
    ucilengi
    New Member
    9 years ago

    Hi. When I import the excel file, it does not see the tables on powerpivot. it only detects the tables on excel itself. even if it did, it would not be the way to go for me. I want to connect my power BI to sccm data feed, which is only possible by atom files.

  • ucilengi's avatar
    ucilengi
    New Member
    9 years ago

    Hi v-qiuyu-msft,

     

    I tried importing the contents of the excel file. However, Power BI desktop does see the tables. But that's two levels of integration. Power BI can take OData but cannot take atom files. I would rather depend on the original connection rather than connecting to an excel file. 

    • 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.