Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Scheduled Refresh with Access Databases???

Hi Team,   Need a Quick Help please . I have data coming from an Access database to Power BI report design. I completed report in Power BI desktop and published it in Work Space. However, I am not ...
Need Help
Show and Tell
LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

try to use the Network path in place of the drive name ( Z )

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have used the complete path name LivioLanzo.No Luck .

 

Could you explain more to resolve this issue ?

  • LivioLanzo's avatar
    LivioLanzo
    Solution Sage
    7 years ago

    Did you correct the path within your Power BI Desktop and then re published it into the service and added the correct source to the gateway ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      In my Power BI Desktop, location to database still looks like this . Attached screenshot for reference.

       

      Z:\Share\Helpshr\Analytics\Power BI\TVM Databases\TVM Patching.accdb

       

      Do I need to change this as well ? If yes, how should it looks like ?

       

       

      Also attached is the original location how it looks when i Open it in my laptop

       

      • LivioLanzo's avatar
        LivioLanzo
        Solution Sage
        7 years ago

        Anonymous

         

        yes you need to change it in the Power BI Desktop, using the networkpath in place of the drive name, and then re publish your file to the Cloud