Forum Discussion

gaofiore's avatar
gaofiore
Frequent Visitor
7 years ago

Issue pulling data from D365 Business Central - Couldn't load the data for this visual

Hello,   I am fairly new to Power BI and I am trying to connect our D365 Business Central to Power BI. I keep getting the following error:   Couldn't load the data for this visual The expression...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi gaofiore 

Do you connect to "D365 Business Central" on premise or online with Power BI Desktop?

It seems you connect to "D365 Business Central" on premise with Power BI Desktop, then publish report to Power BI Service.

the error you reveice is from a visual on Power BI Service.

Right?

If so, you need to download a on-premise gateway, add this data source under the gateway and set schedule refresh for the dataset.

Please refer to the following documents

Install a gateway for Power BI (on-premise, not personal mode)

Configuring scheduled refresh

Dynamics 365 Business Central (on-premises) Authentication

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • gaofiore's avatar
    gaofiore
    Frequent Visitor
    7 years ago

    Hi Maggie,

     

    We have Business Central but not on Prem.

     

    I am trying to connect using PowerBI online, using the Business Central App but get no data and that error. Are you saying I should use PowerBI for desktop? i was hoping to take advantage of the pre built views and charts and such...

     

     

    Thank you

    • MaryMThompson's avatar
      MaryMThompson
      New Member
      7 years ago

      gaofiore 

       

      I am having the same issue.  Did you have any luck working through this?