Power BI Direct Query with Business Central Online

[samantha75]

Hi All

Is there a way to connect to Business Central SaaS using Direct Query? If not what are the options to get the latest data? Manual refresh could be the only option

Thanks

[samantha75]

Thanks 

At this stage i'd just like confirm my understanding Direct Query is not available so I'l figure out an alternative

[v-yadongf-msft]

Hi @samantha75 ,

In order to better understanding your demands and give the right solution, could you please tell me what's your expected output?

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.