Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all:
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.
Any idea?
Thank you in advance.
Solved! Go to Solution.
Do you have any other problem about this scenario?
Best Regards,
Herbert
You can publish the google sheet to web to get the excel link as following screenshot. Then get data in Power BI Desktop using the web connector with the excel link.
Please also vote on following idea to push the product team to make it to be a built-in connector in the future.
Best Regards,
Herbert
Sure, that works. But, what happen when you update data in this file? Can you use the same link or you have to change it?
You do not need to change the link and you can refresh the data by clicking Refresh in Power BI Desktop.
Best Regards,
Herbert
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?
thank you for your comments Herbert
Hi, I am new to Power BI.
I tried this method to connect to the Google sheet.
But instead of getting the table data in the Power BI Navigator, I get a pop up dialog to download the Google sheet from my browser. Along with this, the table 0 looks like this.
With every refresh, I get a dialog box to let my browser download the Sheet.
Please advise on how to fix this.
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.
Best Regards,
Herbert
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |