Forum Discussion

Powerbiuser2000's avatar
Powerbiuser2000
Frequent Visitor
2 years ago

Power Bi refresh error

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 spr...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.