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...
Hello,
This method doesn't work for for me. I saved report created in CRM365 as Data Feed (ATOMSVC file) and I've tried to get data as Web to Power BI and it doesn't work because the URL have wrong hostname :
Details: "The remote name could not be resolved: 'amscrmp629agl01.phx.gbl'"
Could you support me with information how to get data from CRM365 report directly to Power BI ?
Best Regards,
Lukasz
I'm trying to do the same thing but just wanting to open the atomsvc in Excel.
I'm guessing the the ...phx.gbl address is the address of the report server in the Microsoft cloud that is running the report. Clearly this is not publically accessible - does anyone know if atomsvc files can be used to return Dynamics 365 CRM report contents?