Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PBI and Dataset issue

Am currently connecting power Bi deaktop using Microsoft Project online.The data source maintained by Client .Noticed that the data is not getting updated in PBI when data set refreshing ? What was wrong ,How and where to check?

Need Help

6 Replies

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

    Anonymous you should check in power bi service, click on dataset -> settings and check refresh history and see if there is any error. Most likely when one published the report first time, you have to enter your credentials on published dataset in power bi service.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I dont see any issue when looking into refresh hisotry in BI service. What are other options to trace the issue?

      • edhans's avatar
        edhans
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Will it refresh in the desktop client if you hit Refresh All? 

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

    Hi, Anonymous 

     

    I wonder if there are some error message in 'Refresh Histroy' in Power BI Service and the status of the gateway is online. There are three main data access scenario:

    • A dataset uses data sources that reside on-premises
    • A dataset uses data sources in the cloud
    • A dataset uses data from both, on-premises and cloud sources

     

    If your dataset uses a data source that Power BI can't access over a direct network connection, you must configure a gateway connection for this dataset before you can enable a refresh schedule or perform an on-demand data refresh.

     

    You may go to 'Manage Gateway' in Power BI Serivice and add data source definition to the corresponding gateway. Also make sure your gateway admin adds your user account to the list of users with permissions to use the data source. Then The dataset settings page lets you select an enterprise gateway with a matching data source that you have permission to use. Make sure you map the correct data source definition to your data source.

     

    Finally you can configure-scheduled-refresh or click 'Refresh now' for the corresponding dataset to refresh data.

     

    Best Regards

    Allan

     

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