x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 386 views
  • Users 0 members are here
Browse Forums
Announcements
238
topics
27
replies
General Discussion
1k
topics
3k
replies
Intelligence Reporting
311
topics
787
replies
Wessel Wouda

Automating PowerBi Reports

SUGGESTED
Posted By

Good day,

I am trying to create some PowerBI reports using the data from the Sage 50c Pastel Partner Data.

Although there are some methods that allow me to do this by exporting data manually. I am looking for an automated solution.

I have managed to set up the 32 Bit ODBC connection to the Sage data. This then allows me to import into PowerBI. However to automatically refresh this data the connection needs to be a 64bit for the Gateways to update.

I have investigated using a SQL DB as a middle man between Sage data and PowerBI by pushing the data to SQL but not sure if this is the best way forward or how to set up the connection. 

Have somebody found a solution to the above that can help me?

Regards,

Wessel

  • 0
    SUGGESTED

    Hi Wessel Wouda,

    To setup a 64-bit connection, you need to run the ODBC from
    C:\Windows\SysWOW64\odbcad32.exe instead of the default. However, I can't confirm if that will automatically refresh the data or not. But let's see if others have a different solution.

    Please verify or reply and let us know if the suggested answer helped in resolving your query.
    To verify an answer simply go to your post and click “More” > “Verify Answer”.

    Regards,

  • 0 in reply to Mapule

    Hi Maps_NGELE

    So i tried adding a new ODBC connection with the exe specified but I still had no luck. So with a 32bit version of PowerBi or with custom scripts I can access the two ODBC connections in the screenshot below on the left. I can then pull the data (but this is not automated)

    The DataGateway that PowerBi use to automatically update the data only runs on 64bit. I tried to add the same Pervasive engine ODBC connection on the 64bit but I don't it does not show in the list as you can see.

    I am not sure if it is possible to download a 64bit version of the ODBC connection drivers or a way to use the 32bit connection in a 64bit application?

*Community Hub is the new name for Sage City