Power Bi refresh error

[Powerbiuser2000]

I created a Power Automate flow so whenever I receive a spreadsheet from a certain email address it downloads the spreadsheet into a specific folder. I then created a Power Bi report based on the spreadsheets in the folder. When I refresh the report in the desktop app it recognizes any new spreadsheets that have been and updates the report with the new data. I published the report to the Power Bi service and get the below error whenever I try to refresh the data. 

Could someone please help me with what I'm doing wrong?

Thank you.

{"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 cloud file is denied.\r\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":

[Anonymous]

Hi @Powerbiuser2000 ,

Please try below steps:

1. Check Permissions:
- Ensure that the account used by the Power BI service has the necessary permissions to access the cloud folder where the spreadsheets are stored.

2. Configure Gateway:
- If you are using files from a local folder, ensure you have a data gateway installed and properly configured to connect to the folder from the Power BI service.
- If you are using cloud storage (like OneDrive or SharePoint), make sure the data gateway is not required or is set up correctly for the type of connection you are using.

3. Update Credentials:
- In the Power BI service, go to the dataset settings and update the credentials to ensure they are correct and have the necessary permissions to access the file.

4. Check File Path:
- Verify that the file path specified in the Power BI report is accessible and correctly mapped in the Power BI service.

5. Tenant Settings:
- Confirm that your Power BI tenant settings do not restrict access to the cloud files.

6. Refresh the Dataset:
- After ensuring the above settings are correct, attempt to manually refresh the dataset in the Power BI service.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[collinq]

Hi @Powerbiuser2000 ,

I am wondering - do you have the gateway setup with the folder as the data source?  Also, are you using the Power Automate visual or are you using Power Automate outside of Power BI and then just trying to hit the results?

[Powerbiuser2000]

I'm using Power Automate outside of Power Bi. I double checked and the connection type is Folder as the data source under my gateway setup.