Forum Discussion
Helper IISelf entered data table cleared after refresh from Service-tool
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).
Helper IISo you mean I should use an Excel file as a datasource containing the information I just put in using "Enter data"? cs_skit
Resolver IVYeah you can do it its quick to create and import and if its just a static table disable refresha nd its fine
You could also type the table manually in M but your probably more comfortable with Excel.
In PowerQuery/Query Editor when importing from Excel use "First Row as Header" function after you imported.
Strangely I just tried with "Enter Data" and I did not get the problem you are having data stays on refresh.
- CJMolin
Hi,
Even after you refreshed it from the Service interface? I have no idea what could be wrong.
Now I am facing "credential problems" when im trying to use an excel file as a data source.... im getting crazy over here :)
- cs_skit
WTF??? that sounds strange... these are the steps
- You are in PowerBI Desktop
- Click Get Data - Excel
- Load Excel file from your PC into PBIX as new table
- Disable Refresh on that table in Query Editor
- publish to Service
can you maybe post some screenshots if you still have problems?
- CJMolin
Its so strange.. My current report which is EXACTLY the same, but with entered data instead of Excel data source data..
heres the message i get so i dont even know if the data clears or not.... :(