Forum Discussion

jashjacob's avatar
jashjacob
Icon for Helper I rankHelper I
6 years ago

Filter data from the Business Central source before retrieving it

My company has many reports with MS Business Central as a source. After a recent update to Business Central, many of the reports are failing. The cause of this is some specific dataset in the Busines...
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

jashjacob I don't know much about BC, but seems like the table is completely removed or changed and Power Query now cannot see that table, correct?

jashjacob's avatar
jashjacob
Icon for Helper I rankHelper I
6 years ago

That's the thing. The table I am trying to retrieve is visible. My guess is, in business central we have something like a view on top of actual tables. This probably is one of the underlying tables that is causing the issue.

 

Even I don't know enough about Business Central to answer further. So, looks like I have to wait till they are able to solve the issue. 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    jashjacob bottom line is if the underline data table is not available regardless what is the source, you cannot do much on Power bI side, let's you are connected to CSV file and that CSV file is renamed or not available, you either have to bring that CSV file back or change to the new file. So in this case, if the underline table is not available, not sure you can do much until it is fixed.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!