Cannot get a line graph based on a pivoted table to auto refresh

[PowerBI-ELM]

Hello,

I have a SQL database with a large number of transations from plant sensors.  

  Time, SensorName1,  Value

  Time, SensorName1,  Value

  Time, SensorName2,  Value

  Time, SensorName3,  Value

etc.

I can build a line graph ( with a data from a Direct Query), set the filters to a SensorName and it draws nicely and the page refresh works as it should (in my case every 30 seconds)

    Time,  SensorName1Value, SensorName2Value

Now I want to draw a line graph with two trend lines on it (SensorName1 and SensorName2), so i set up a table, using an import query and use the query editor to pivot it.  The line graph looks ince and refreshes every 30 seconds but in this case the underlying table does not refresh automatically.

It is almost as if a table built with an import query does not auto refresh like the direct query one does.

Any suggestions?

- I have created a view in SQL that pre-pivots the data but I cannot figure how to load it into PowerBI

Thanks,

Stephen

[otravers · Accepted solution]

Stephen, you guessed right about the source of your refresh issue. Automatic refresh doesn't work for Import sources, but you could merge your DQ and Import tables in a composite model:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

Import tables have to be refreshed via a dataset refresh, they're not happening in real time and they're limited to 8 a day in shared capacity. 

There's nothing special about loading a view, they're listed alongside with tables when you connect to a SQL database, can you elaborate on what the issue is?