Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Reduce the Number of Records Pouring In

Posted on by Microsoft Employee

Hi:

Through an ODBC connection to the GP company database, we chose the AccountTransactions view from which to pull records into Power BI.  But, it's a lot.  We're talking millions upon millions.

We tried clicking the "Transform Data" button, as a possible solution.  But, upon trying to filter the data based upon say "date", we could no longer find any records associated with the general ledger account number we want to report on.

Why would Transform Data not provide all data?

Regardless, what is the best way to filter on data so that the end user is not sitting in front of her monitor waiting for all of the records from the view or table or whatever to finish pouring into Power BI as she is having to do right now?

Thanks!

John

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,009 Super User on at
    RE: Reduce the Number of Records Pouring In

    Pinging in here Belinda Allen as she has a wealth of knowledge on PowerBI & GP data queries. 

  • Nicole Hellerud Profile Picture
    Nicole Hellerud 1,710 on at
    RE: Reduce the Number of Records Pouring In

    Hi John,

    Thank you for your post. 

    I do not have a specific suggestions on the "Transform Data" functionality in Power BI, but I did want to offer https://community.powerbi.com/ as another possible source for support on this issue.

    Has anyone else in the community come across this issue and can offer John some suggestions?

    Best Regards,
    Nicole Fiskum
    Support Engineer
    Microsoft Dynamics GP

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans