Forum Discussion

mohammedusman's avatar
mohammedusman
New Member
9 years ago

Opera 3 Foxpro Database

Hi,

 

I've recently started using Power BI and still getting to grips with it and trying to get some better and live reports from our finance system Pegasus Opera 3, which I've managed to export directly into MS Access by adding a data source in Windows. However, I am unable to the same for Power BI.

 

Is there a way to link Power BI to .dbf file types?

 

Regards

3 Replies

  • v-micsh-msft's avatar
    v-micsh-msft
    Microsoft Employee
    9 years ago

    Hi mohammedusman,

     

    Apologize to say that currently Power BI doesn't support .dbf file.

    There is already an idea submitted on this topic:

    dbf

     

    To workaround this, we could first import the data from .dbf file into Microsoft Access or Microsoft Excel, then save it into the other file type, such as Access database type or Excel worksheets, then user Power BI to import the data from the converted file.

    Adding some reference:

    Data sources in Power BI Desktop

    Regards

    • KBev's avatar
      KBev
      New Member
      9 years ago

      Are there any plans to have foxpro databases supported in Power BI?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        bump

         

        I am looking to connect to an accounting suite called Pegasus Opera 3 which is a FoxPro database.  Is there a connector or method to access the datab ase.  I undertand it to be a .bdf file.

         

        Any luck anyone?