I have developed a model linked with Google Drive, and have problems with data update.
Every month we do next:
- generate .csv with the same link
- then we open then in spreadsheet and generate the links in order to link to Power BI. The thing is that these links are not permanent (contrary to the csv), so every month we change them and there is no a complete automation.
- furthermore when I import data to Power BI in some columns the system adds 'commas' after some number columns.
I share the report on Service Power BI and schedule the update. I don't need to refresh whether I do that. I mean, the issue is that in order to update data in excel file and then maintain the same link to connect to Power BI, how I should proceed?
If you get data from Google Sheet through Web connector in Power BI Desktop, then publish the reprot to Power BI Service. You only need to schedule refresh for it. Please refer to my screenshot below. Once the schedule refresh is triggered, the dataset will be refreshed. You do not need to do other thing like changing the link.