Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Report not refreshing on Power BI

Hi,

I am new to Power BI. I created a report on Power BI Desktop. The report uses a ODBC connection to Snowflake and to display the data from the database. It works fine if I click refresh on Power BI Desktop. But when I publish it and refresh the data it doesnt work. I have tried both ways:

1. Clicking refresh on the report

2. Refreshing Dataset on Power BI server by clicking Refresh Now and then clicking refresh on the report. 

Can you let me know what can I do see the refreshed data on Power BI Server instead of refreshing it on Desktop and publishing it again and again. 

I am using Power BI Desktop May 2020 version. I am using a Personal Gateway and its up and running and also executing the query on the database when I refresh the dataset.

Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    If you have configured gateway successfully, when you refresh data, it should work without anything specific and after you see refresh sceessful in the refresh history, the report should be the latest.

     

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    what does the Dataset refresh history say? Any error messages?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Dataset refreshes successfully. Is there anything specific that needs to be done to refresh the report when the dataset refreshes?

      • v-yingjl's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

        If you have configured gateway successfully, when you refresh data, it should work without anything specific and after you see refresh sceessful in the refresh history, the report should be the latest.

         

         

        Best Regards,
        Yingjie Li

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    1. Many issues can surface when the gateway version is out of date. It's a good general practice to make sure you're on the latest version. If you haven't updated the gateway for a month or longer, consider installing the latest version of the gateway. Then see if you can reproduce the issue.
    2. You can check whether you have configured the data source of gateway correctly.
    3. Please try to use on-premiss gateway to try it again.

    You can also refre this document about personal gateway troubleshootings: Troubleshooting Power BI gateway (personal mode) 

    Since there is no clear information about your refresh, if the above not help, you can share some error messages and screen shots about it for further discussion.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.