Context:
I worked on a dashboard that's pulling dozens of sheets and merging them together into a dataset. It's time-consuming to add each Sheet to PowerBI and requires many manual steps.
I've explored using a Report as it can automatically pickup new sheets automatically, adds the sheet name, etc. When I import into PowerBI desktop, it works great. Fewer columns needed, only querying what we need from Smartsheet (which reduces our hits to Smartsheet's servers via the driver). It also looks good after uploading the dashboard into the Power BI service. Data range matches desktop, visuals all populate. It should be a dream, right?
Where it falls apart:
Once the PowerBI service engages its automatic refreshes, certain visuals just stop displaying any data.
