Forum Discussion

aitorNAV's avatar
aitorNAV
Regular Visitor
6 years ago

Problem with business central DataSource

Hi everyone,   A few weeks ago, we created an integration of powerBi and business central. The scheduled refresh was working correctly, until we received this error:   In the desktop powerB...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

aitorNAV can you see other tables available in the BC? Seems like something changed at the endpoint, not sure if it is this particular table or it is a connection.

  • aitorNAV's avatar
    aitorNAV
    Regular Visitor
    6 years ago

    Thanks for your answer parry2k .

     

    I get this error if I try to use business entral as dataSource. Instead of that, if I try to use oData as data source, and add the only oData service that is not in the standard, I didn't get the error. So i understand that the problem is not in that table.... I admit that I am quite lost

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      aitorNAV can you start a new pbix and test odata to see if you can connect and then we can come back to existing report. First and foremost you have to connect to data source and see if you can pull the tables.

      • aitorNAV's avatar
        aitorNAV
        Regular Visitor
        6 years ago

        I am opening the powerBI without without any pbix,  I'm using a new one jsut for testing the sources....