web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Problem with Power BI ...
Business Central forum

Problem with Power BI Finance app installation

(0) ShareShare
ReportReport
Posted on by MikkoB

Hi all,

I'm trying to install the app from Microsoft appcentral called 'Dynamics 365 Business Central - Finance'. So I'm downloading it via PowerBI.com site. and after the installation it throws error: "We couldn't install Microsoft Dynamics 365 Business Central - Finance. There was an error when processing the data in the dataset". In details: "Data source error: The 'Number' column does not exist in the rowset. Table: powerbifinance."

Does anyone know how to fix this kind of error? The other Microsoft provided power bi-BC apps works fine.

Categories:
Other
Reports and Business Intelligence
  • jland555 Profile Picture
    jland555 75 on at

    I'm having the same issue.  Did you find any resolution?

  • MikkoB Profile Picture
    MikkoB on at

    Sorry, no - it seems like nobody uses it?

  • PADu Profile Picture
    PADu 35 on at

    I get the same error.

    What versions of BC are you running? I am wondering if these packs are set up for a different version to the one we are running?

  • Mary Myers Profile Picture
    Mary Myers 2 on at

    I have been getting this error trying to use the Customer List app.  Says data won't load, and this is the error code. Couldn't load the data for this visual

    The query referenced calculated table 'Dates' which does not hold any data because it needs to be recalculated or refreshed.

    Please try again later or contact support. If you contact support, please provide these details.

    Activity ID: 810b2fe7-99f5-45ae-901f-72ee9215b0c5

    Request ID: 372047b8-e0b0-3036-e858-32699e3463a9

    Correlation ID: 756b7fc6-034a-ec9b-1eea-3d7f6dcba49d

    Time: Tue Jun 11 2019 15:37:27 GMT-0400 (Eastern Daylight Time)

    Version: 13.0.9703.183

    Seems like a different error, but wonder if you have any insight

  • jland555 Profile Picture
    jland555 75 on at

    It's not really a different error, it's just a difference location.  I see this same error when looking at the KPIs/Charts, and the original error when looking at the related data set.  

    I'm using the online version with the CONTOSO database, but I do have clients who are looking to roll this out for real and I'm hesitant to bring it up until we know what the issue is.  I'm working on opening a case with the Power BI group to see if we can find a resolution, so if it goes anywhere, I'll update here.

  • Mary Myers Profile Picture
    Mary Myers 2 on at

    Check out this link.  I already submitted one, but your input and additions would be wonderful!

    community.powerbi.com/.../713093

  • jland555 Profile Picture
    jland555 75 on at

    So, I went down the path of contacting the Power BI support group about this.  Basically, the consensus is that if we can connect through the desktop Power BI to the Business Central instance (which we can), then the issue is with whoever developed the app and the Business Central data.  So the next step is to open a support case with the Business Central group.  I'm still trying to figure out how to do that, since I can only find support for on-prem and not cloud.

  • MikkoB Profile Picture
    MikkoB on at

    Thank You so much for escalating the case. Let us know if you find out something.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans