Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI Service Refresh

Hi, there.

 

I am not able to refresh my table in PowerBI Service although it works fine in the Desktop version.

 

I have a table created in PowerBI Desktop that is not connected to any source. The data is generated from Power Query with the Name field hard coded and Value field being a random number:

 

= Table.InsertRows(Table.FromRecords({[ Name = "Ferrari", Value = Number.Random()], [Name = "Porsche", Value = Number.Random()]}), 1, {[ Name = "Bugatti", Value = Number.Random()]})


When I click on Refresh in Desktop, I get a different random number every time. In PBI Service, nothing happens... 

 

Any idea?

Need Help

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    I think this is due to when in the service all the refreshing actually happens to a data source.

    In your example you are not connected to any data source, so it cannot refresh it.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, GilbertQ. 


      I added a SQL database as a source. Now I multiply the random value with a value from the database, but that's still not working.

       

      Desktop gets updated as expected but nothing happens online. 

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago
        Hi there

        Ok then the reason must be, because there is no actual item that is causing the table to initiate a refresh that it is not refreshing the number?