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).

     

     

cs_skit's avatar
cs_skit
Icon for Resolver IV rankResolver IV
9 years ago

Yeah 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's avatar
CJMolin
Icon for Helper II rankHelper II
9 years ago

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's avatar
    cs_skit
    Icon for Resolver IV rankResolver IV
    9 years ago

    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's avatar
      CJMolin
      Icon for Helper II rankHelper II
      9 years ago

      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.... :(

       

      • 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