Forum Discussion

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
    11 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.

     

    :(