Can't get my PowerBi Data Gateway to refresh

Anonymous
2023-08-15T01:53:29+00:00

I get this error whenever I try to refresh my dataset. Any tips on how to bypass or fix it?

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Access to the path 'C:\Users\velas\OneDrive\Documents\PBI Everything\ChaseBank BI\ChaseBank2.pdf' is denied."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"FILE PATH"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Table03 (Page 4).

Cluster URI: WABI-US-CENTRAL-B-PRIMARY-redirect.analysis.windows.net

Activity ID: 265232ca-c5e2-43ee-b522-4cbaa275a189

Request ID: 50ae8a97-a313-9464-7e9d-ae23dfa979dd

Time: 2023-07-25 01:55:19Z

Microsoft 365 and Office | Install, redeem, activate | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-08-15T04:35:53+00:00

    Hello Angel

    I’m Adeyemi and I’d be happy to help you with your question.

    It seems that the error you're encountering is related to the access to the file path C:\\Users\\velas\\OneDrive\\Documents\\PBI Everything\\ChaseBank BI\\ChaseBank2.pdf being denied. This could be due to a number of reasons, such as incorrect file permissions, the file being open in another program, or issues with the OneDrive sync.

    Here are a few things you can try to resolve this issue:

    1. Check file permissions: Make sure that the account running the Power BI Data Gateway has the necessary permissions to access the file.
    2. Close other programs: Make sure that the file is not open in another program, such as a PDF reader or editor.
    3. Check OneDrive sync: If the file is stored in OneDrive, make sure that it is properly synced and accessible.

    I hope this helps

    Regards Adeyemi

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-09-24T23:16:28+00:00

    Thank you, I'll post my answers there!

    Best,

    Was this answer helpful?

    0 comments
  3. Stefan Blom 349.1K Reputation points MVP Volunteer Moderator
    2023-09-16T17:31:51+00:00

    For future reference, note that there is a dedicated forum for Power BI users, where you are more likely to get specific assistance:

    https://community.fabric.microsoft.com/t5/Microsoft-Power-BI-Community/ct-p/powerbi

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-09-15T20:37:22+00:00

    Hi Adeyami,

    Thank you for the solutions. I'll try them out and post on whether it worked or not. Much appreciated!

    Best,

    Angel V.

    Was this answer helpful?

    0 comments