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 IIIts 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.... :(
Community SupportHi 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
Thank you very much for your long answer. I realised it could be working if I was using a personal gateway. Unfortunately we're not allowed to use personal gateways on the company since we want to be all cloud based. So that brings this thread back to the main question I supppose.. :(
Thank you very much again!
CJ
- v-qiuyu-msft
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
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.
- CJMolin
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
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
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).