Forum Discussion
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 PowerBI desktop which runs perfectly fine by a scheduled refresh setup in the Power BI Service. One of the tables are "self entered" using the "enter data" function. I use this table as a lookup table creating measures calculacting performance from this "hardcoded" table.
Problem:
When I am refreshing my dataset in Power BI Desktop everything is working as it is supposed to. ALTHOUGH! When I publish my report to the service interface and i refresh the report from there my "self entered" data table clears and my measures related to this table of course will be blank in the service interface.
I have no idea how to solve this and Ive been googling alot! Anyone know how to fix this issue?
Thanks alot!!!
CJ
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).
15 Replies
In PBI Desktop if you go to Query Editor and remove that checkbox:
for the table in question only (right click it) before publishing
does that fix your issue?
Yeah sorry for those static tables I usually icreate the table in Excel quickly import and then stop the refresh I actually never published Enter Data stuff so far let me try that fast :)
