Forum Discussion
Update data from Navision everytime PowerBi opens
Hi I have made a report from two tables in our Navision system. The tables are linked in PowerBI Desktop via Odata. I have shared this workcenter with some colleges, but when they open the report ...
can you show the sanitized Power Query code for how you connect to Navision?
I be happy to do it, but how do I do it?
Right click on the query, Advanced Editor, then copy the Power Query M code and paste it here. Make sure to mask sensitive data.
Here:
Source = OData.Feed("http://yyyy.yyyy.local:7048/TRIMIT/OData/Company(yyyy)", null, [Implementation="2.0"]),
PCO_List = Source[PCO_List],