Power BI Refresh Issue

Hi Anonymous 

Let's address the issues you're experiencing with your Power BI report:

1. Publishing vs. Data Refresh:

• Publishing Changes: When you modify your Power BI Desktop file (e.g., adding a new page or text) and publish it to the Power BI Service, these structural changes should reflect in the online report. If you don't see the updates, try refreshing your browser by pressing F5 or clearing the cache to ensure you're viewing the latest version.

2. Data Refresh:

• Understanding Data Refresh: Refreshing the data in Power BI updates the dataset with the latest information from your data sources. This process is separate from publishing structural changes.
• Gateway Configuration: Since you've installed a gateway on your laptop, ensure it's properly configured and running. The gateway facilitates data transfer between on-premises data sources and the Power BI Service. Verify that your data source credentials are correctly set in the Power BI Service under Settings > Datasets > Data Source Credentials.

3. Common Issues and Solutions:

• Credentials Greyed Out: This typically indicates that the Power BI Service cannot authenticate with your data source. Ensure that the credentials provided are correct and have the necessary permissions.
• Gateway Status: Confirm that the gateway is online and connected. You can check its status in the Power BI Service under Manage Gateways.

For a comprehensive understanding of data refresh in Power BI, you might find this Microsoft documentation:
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data

And the linked video:

https://www.youtube.com/watch?v=DWIfGWaUCdU

Hi Anonymous 

If you want lastest changes in public link (on service) so you have to either setup a proper gateway for refresh or publish the report again from desktop to PBI service.

Gateway: It only refreshes the data from your database. if you are using local excel file or any Database in your local system you have to install private gateway. 

But if your Database is on other server  you have to install enterprise gateway on the other server where your database is installed. 

Installing on premises gateway on your local system wount help you.

If database is on any cloud platform( aws,azure) you dont have to install any gateway diret credential would help you to create connect with cloud databse.

Note: If you make any changes in your power bi desktop file( add new chart, new column to you table, any dax) you have to publish everytime to PBI service. because gateway refresh wont reflect your desktop changes.

I hope I have clear your doubts.

I hope I answered your question!