Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I ran an import query against an sql server on power bi desktop and then uploaded the file on to powerbi service. I've set up the gateway and want the data to refresh when I click refresh but it does not update with the latest data from the query. I am not sure if the query was actually uploaded or just the data from my query when I put on power bi service. How can i configure power bi service to run the query when I click refresh?
Solved! Go to Solution.
Hi, @Anonymous
If you configure the gateway correctly, you can click the two buttons to refresh. You can see the refresh history in dataset>>more options>>setting>>refresh history.
If you have opened the report, you can refresh to get the latest data through the refresh button on the browser and the refresh button on the report (Make sure that the dataset has been refreshed at this time).
Here you can view the latest update time of the report:
@Anonymous Sounds like you are hitting the refresh button in the Service on the report page. That simply refreshes the report visuals, it doesn't actually refresh the data. You need to schedule a refresh on the dataset.
Never mind it is refreshing the data but the report is just not reflecting it. Do you know how I can update the report? I don't see a refresh option on it.
Hi, @Anonymous
If you configure the gateway correctly, you can click the two buttons to refresh. You can see the refresh history in dataset>>more options>>setting>>refresh history.
If you have opened the report, you can refresh to get the latest data through the refresh button on the browser and the refresh button on the report (Make sure that the dataset has been refreshed at this time).
Here you can view the latest update time of the report:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |