Forum Discussion
How to set up data model connection ?
Hi All
I try to learn how to create auto reload of data at 3 Am.
I have check the setting :-
Refresh can't be scheduled because the data set doesn't contain any data model connections, or is a worksheet or linked table. To schedule refresh, the data must be loaded into the data model.
May i know how to set up data model connection ? So that my CSV file is updated at 2 Am , and PBI can refresh at 3 Am.
Hi Anonymous
I can reproduce your issue when I don’t load data into Power BI Desktop data model. Please make sure that you apply all the pending changes by clicking Apply in Query Editor before saving the pbix file in Power BI Desktop. And you to have installed gateway for the refresh to work once you are done with this everything will work fine
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
1 Reply
Hi Anonymous
I can reproduce your issue when I don’t load data into Power BI Desktop data model. Please make sure that you apply all the pending changes by clicking Apply in Query Editor before saving the pbix file in Power BI Desktop. And you to have installed gateway for the refresh to work once you are done with this everything will work fine
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍