Forum Discussion

motoroto's avatar
motoroto
Frequent Visitor
8 years ago
Solved

Getting data from Microsof Access

Hello, I have a pbix file which source is a microsoft access file (no password protected), I have no problem getting data from Power BI Desktop. However, when i upload the file to app.power.bi.com t...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    motoroto,

     

    Currently, on-premises gateway can't connect to Access database, please use on-premises gateway(personal mode) instead to refresh the Access database.

     

    In addition, there is an idea about adding Access as data source for on-premises gateway, you can vote it up.

     

    Regards,

    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

motoroto,

 

Currently, on-premises gateway can't connect to Access database, please use on-premises gateway(personal mode) instead to refresh the Access database.

 

In addition, there is an idea about adding Access as data source for on-premises gateway, you can vote it up.

 

Regards,

Lydia

motoroto's avatar
motoroto
Frequent Visitor
8 years ago

Thanks Lydia, is there a way to use both, on-premises gateway and on-prem.. (personal mode) for different sets of data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    motoroto,

    You are able to use different gateways for different datasets. However, for a single dataset, you should add all data sources under a single gateway. In other words, it is not possible to add a part of data sources of the single dataset within on-premises gateway and add remaining data sources within in-premises gateway(personal mode), then use the two gateways to refresh the single dataset.

    Regards,
    Lydia

    • motoroto's avatar
      motoroto
      Frequent Visitor
      8 years ago

      Thanks Lidya, now I have it more clear. I´ll have to figure out how to set up 2 gateways.