Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 years ago

Cool, I'll be interested to know if it works with the gateway.

Solutionz's avatar
Solutionz
Helper I
11 years ago

Did nothing...

  • 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