Forum Discussion
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...
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
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.