locked
Power BI Desktop & Access RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    I am having trouble getting refresh to work. 

    What I have setup is follows. 

    I have an access databases with a load of queries that are updated daily. 

    I used Power BI desktop to connect to the Access db to pull in all the queries. The Access db is in SharePoint online.
    I have the PowerBIGateway installed on a production pc. I then added the .PBIX from Power BI Desktop into the PowerBI portal and setup a scheduled refresh . It looks like the scheduled refresh is working but the data does not refresh.

    Is what I am trying to do possible ? I just want some PowerBI reports based on Access SQL queries (local tables) to be updated daily. 

    Appreciate your thoughts

     

    Wednesday, July 29, 2015 10:42 AM

Answers

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Yes, it should be possible:

    https://support.powerbi.com/knowledgebase/articles/474669-refresh-data-in-power-bi

    That being said, it seems like EVERYONE is having issues with Power BI Refresh, myself included.

    Wednesday, July 29, 2015 11:56 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Its definitely not working. As a test I just tried scheduled refresh with a sharepoint list and it worked .. so I guess I could publish the reports to SharePoint lists from Access if I can't get Access via PowerBI desktop to work.
    • Edited by marculos123 Wednesday, July 29, 2015 1:34 PM
    Wednesday, July 29, 2015 1:34 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    That's nifty, that's the one I'm having trouble with, SharePoint Online lists refreshed automatically...
    Wednesday, July 29, 2015 2:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    After more testing this clearly doesn't work, that is scheduled refresh using PowerBI Desktop to connect to queries is an access database hosted on SharePoint.

    The scheduled refresh looks like it is  working on the Gateway production pc, so  I guess will have to think of another way like SharePoint lists which do refresh.

     
    Thursday, July 30, 2015 9:42 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Interestingly, when you publish the pbix directly from Power BI it says that scheduled refresh is not supported. 

    If you add the pbix using "Get data" from the PowerBI portal it allows you to set a refresh schedule that doesn't work !

    You cannot schedule refresh for this dataset because it gets data from sources that currently don’t support refresh. Learn More about data sources that currently support refresh. 
    Hide details
    Activity Id: dcbbb5a4-2459-723b-be14-215093fa6a9b
    Request Id: d152f89c-4ced-03a4-dd04-b496e08c43cd
    Status Code: 200
    Time: Thu Jul 30 2015 11:09:30 GMT+0100 (GMT Daylight Time)
    Version: 11.0.9167.506


    • Edited by marculos123 Thursday, July 30, 2015 10:16 AM
    Thursday, July 30, 2015 10:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I'd encourage you to take this question to the Power BI community @ community.powerbi.com

    Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Wednesday, October 28, 2015 12:36 AM