Forum Discussion

juanlopezmeyer's avatar
juanlopezmeyer
Frequent Visitor
8 years ago
Solved

SQL Server - Import data

Hi everyone;   I have connected a SQL Server to Power Bi. I am importing the data. I need to update/refresh the data everytime that the file is opened. Is that possible? I do not find that option. ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi juanlopezmeyer,

     

    Current power bi desktop not support this feature.(I test with both import and direct query mode)
    Perhaps you can share this requirement to ideas.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

To my knowledge, I think there is noway to update the data everytime you opended the .pbix file... If you publish your .pbix file to service then you can schedule the refresh under the Gateway. 

juanlopezmeyer's avatar
juanlopezmeyer
Frequent Visitor
8 years ago

So you think that the scheduled refresh through the gateway is the only option?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes I think so...