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,

 

For your original issue, I mean when you use entered data instead of connect to local Excel in the dataset, which kind of data source did you use in the dataset?

 

In Power BI service, as long as the dataste contains on-premise data source (eg: SQL Server database, local Excel file), we need to utilize the gateway to build bridge between the Power BI service and on-premise data source. Is there any specific reason that you can't use gateway?

 

If you don't want to use gateway, you can enter all data when you create the report in desktop. Or just connect to online data source which not require gateway, for example: Azure SQL database.

 

Best Regards,
Qiuyun Yu

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

Hello again!

 

I am using a Gateway, but not a personal gateway, see picture attached. The other connection is to a MySqlServer..

 

 

 My gatewaymy self entered data table in power bi desktop. data still there if i refresh in power bi desktopafter published my dataset to service i try to refresh. all of a sudden my meaures are blank due to the table = blanki then download the report again to see whats wrongafter downloaded my refreshed report in pb service i realize this table is now empty.