cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBI-ELM
Helper I
Helper I

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

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

 

 

 

 

1 ACCEPTED SOLUTION
otravers
Resident Rockstar
Resident Rockstar

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?

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog

View solution in original post

1 REPLY 1
otravers
Resident Rockstar
Resident Rockstar

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?

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors