Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 years ago

Yeah, you are correct, as of now, if you create the data set directly in Power BI Service, you cannot refresh it, you have to put it in the a data model. Actually, if you go to Schedule Refresh, it tells you that:

 

"You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model. Learn More about data sources that currently support refresh. "

 

I get what you are saying though, certainly kind of a weird limitation...

 
Solutionz's avatar
Solutionz
Helper I
11 years ago

I'm jumping around here...My data is now refreshing from the Azure SQL..It think the only difference is that I created the data connection direcly in the Power BI interface on the Cloud, not the desktop.

 

If I log out and back in again online I see little wheels spinning and it refreshes...

  • konstantinos's avatar
    konstantinos
    Memorable Member
    11 years ago

    My test: 

    The tiles are not refreshing.( 3 hours ) .Although when you click a tile the report queries the DB and the graphs are refreshing..Strange but the report keeps cached the old data..so when I go back to dashboard & to report it queries again..doesn't keep the latest query values

  • Solutionz's avatar
    Solutionz
    Helper I
    11 years ago

    Me again....

     

    I can now confirm that the Azure SQL data refreshes when I close Power BI and log back in. I suspect it also refreshes after a while (I've not sat waiting to see). The mobile app also refreshes when closed and re-opened..

     

    To get this to work I had to create the "Get Data" connection on the powerbi website...

     

    However, I now have another issue. A new table has been added to the Azure SQL database, it has data and I can query it from MS Management Studio..However, the new table is not showing up on the Power BI Dataset..The data in the existing dataset has refreshed but the new table is not visible.

     

    Any ideas? I hope I don't have to delete the dataset and start again..

  • Sparso's avatar
    Sparso
    New Member
    11 years ago

    Hi, 

    Is there a way to manually trigger schema update? Or will I need to create a new connection, and redo all the reports?

  • Solutionz's avatar
    Solutionz
    Helper I
    10 years ago

    Hi Sparso

     

    At the moment I am assuming that I have to reconnect the dataset for the schemer to refresh. It allows you to connect the same database twice but I suspect that will become messy. So until Microsoft add an auto-refresh or manual (either way is good), I'm rebuilding my reports each time.

     

    :(