Google Sheets is a cloud-based spreadsheet application that can store data in a structured way just like most database management systems. This works for me because my published tables are VERY SIMPLE reference sheets (Like 3-5 columns), but I can't imagine this working for larger published documents.Image via Shutterstock under license to Frank Andradeĭid you know Google Sheets can be used as a lightweight database? So like, publish as web page, use that link, and then different 'applied steps' to get it to look like what your table used to. I tried loading as XLSX instead but I can't seem to tell google sheets that my data is a table.Įdit: My only workaround for now is to edit my MSPBI queries a bit to look at the source as an actual webpage and then format a table based on that instead. Then if you go to "Source" You'll see HTML like in the OPs screenshot. But if you click refresh, and are on the last applied step (Probably "Changed Types") it'll fail. And then you'll see it loaded correctly in the query editor. ODDLY, if you start a new web connection to your CSV you'll see the preview load correctly. The columns no longer exist because if you go to "Source" you'll see HTML code instead of the raw CSV sheet. Now, I get a bunch of errors (Referencing columns that no longer exist).
For weeks I've had google sheets published online and I've connected to them as a CSV. I keep trying to reply to this and it keeps disregarding my reply. Apparently, Google changed this without notice. That is rediculously **bleep**ty because I used the 'publish on the internet' feature which is a completely different menu option and didn't need a change in 'share' previously. The solution is simple: Go to file > share and change it to 'anyone with the link can read' (or something like that, I'm not using Docs in English).
But it doesn't as of this Thanks for your backup. Your solution should work, as my solution should work as well. Remember: the Google link worked flawlessly for months and I didn't change the report at Thanks for your reply. In a browser, you don't see this but Power BI fails randomly. Though the settings are so that it is publicly published, it appears to redirect to a login page only to check that a login is not required and then continues or something.
I checked the HTML page a little further, and it is a login page.
0 kommentar(er)
