Forum Discussion

KasperJ90's avatar
KasperJ90
Helper III
5 years ago

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 ...
Dataflow
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

You can only do that if your data source supports direct query mode or live connection mode. 

If your data source only supports import mode then you need to increase the dataset refresh schedule, or use API based refresh that can be controlled by updates in your data source.

  • KasperJ90's avatar
    KasperJ90
    Helper III
    5 years ago

    Thank you for your response.
    How do I know if my data source supports direct query mode? I have linked PowerBi Desktop to 2 public queries in Navision and made my report with data from these two queries.

     

    How can I get it to update everytime someone open their report or refresh it?

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      can you show the sanitized Power Query code for how you connect to Navision?

      • KasperJ90's avatar
        KasperJ90
        Helper III
        5 years ago

        I be happy to do it, but how do I do it?