Power BI Service Refresh

[Anonymous]

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?

[GilbertQ]

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]

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]

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?