Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dear Experts,
I have a Power BI dashboard on Power BI Desktop connecting to 9 to 10 Google sheets. Each day the sheets are updated on Google sheets and and normally, I use the refresh button on Home tab (next to transform data) which updates the dashboard and was working fine. At that time I haven't installed the May 2022 and was using the Google Sheets beta connector. Today I installed the update and now when I use that refresh button, I am getting error messages. The only weird thing for me is that the refresh button in Power Query Editor is not having any issues. Please guide me how to find source of issue or how to rectify it.
I also cannot share the file so please do not ask
The messages I get when refreshing from Home tab in Power BI desktop:
Ive tried clearing the permission from data source settings as well clearing all table relationship in model view but niether succeeded.
Also below is the table relationship for refernce
Solved! Go to Solution.
Issue resolved
I did try that but I got the same error
Issue resolved
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |