Forum Discussion

CJMolin's avatar
CJMolin
Icon for Helper II rankHelper II
9 years ago
Solved

Self entered data table cleared after refresh from Service-tool

Hello,   First of all Im not sure if this topic should lay under Desktop or Service since it concerns them both, sorry if I put it wrong.   Background: I've created a pretty big data model in Po...
Need Help
  • CJMolin's avatar
    CJMolin
    9 years ago

    Thank you for all your help Qiuyu.

     

    I was able to fix this issue with the help of one of our IT guys at work. He put up a new database for me so I can use it for lookups (so i had a source to point at at refresh).

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi CJMolin,

 

From the screnshoot, the dataset contains on-premise data source, so it requires gateway to act bridge between the on-premise data gateway and on-premise data source.

 

In your scenario, please download the on-premise data gateway and install it follow this article: On-premises data gateway . Then you can go to Manage Gateways, create two data source use the same connection information as used in Power BI desktop. Take the SQL Server data source as example, you can see: Manage your data source - SQL Server.

 

 

Or you can install the On-premises data gateway (personal mode), then you can see on-premise data gateway (personal mode) is available and you are able to edit data source.

 

 

Best Regards,
Qiuyun Yu

CJMolin's avatar
CJMolin
Icon for Helper II rankHelper II
9 years ago

Something that might work is if there is a possibilty to "disable" my static self entered data table to be refreshed when im trying to refresh through the PBI service.. is that possible v-qiuyu-msft?

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi CJMolin,

     

    In Power BI service, we are not able to refresh a part of data source in one dataset.

     

    I'm not reproduce the issue on my side. In your scenario, please open the downloaded .pbix file in Power BI desktop version 2.48.4792.721 64-bit (July 2017).

     

    Best Regards,
    Qiuyun Yu

  • CJMolin's avatar
    CJMolin
    Icon for Helper II rankHelper II
    9 years ago

    Thank you for all your help Qiuyu.

     

    I was able to fix this issue with the help of one of our IT guys at work. He put up a new database for me so I can use it for lookups (so i had a source to point at at refresh).