Forum Discussion

AdrianSko's avatar
AdrianSko
New Member
3 years ago

Loading ODC file/pivot table to Power Query

Hello, I do have an odc file for excel connection, which after opening is giving me access only to create pivot tables or charts based on the query to which I don't have direct access.   Is that po...
Need Help
Show and Tell
foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
3 years ago

The .odc file is the connection within Excel only. Power BI Desktop can't import or directly use it. However, you can read the source in the .odc file. Then connect it from Power BI Desktop. 

foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
3 years ago

Open the ODC file in Notepad to examine the XML format used.