-
(500) Internal Server Error - Power BI
Hi All, I use Smartsheet as a data source often in Power BI. For the last two years I have never had an issue with Smartsheet's API, but today I have been getting a "Web.Contents failed to get contents from <insert smartsheet URL here> (500): Internal Service Error. Is this happening to anyone else? Or is this just a me…
-
How do you avoid Power BI Semantic Model Error when column headers are modified (add/remove/edit)
For anyone connecting Smartsheet with Power BI and using sheets as sematic model, and set a scheduled refresh, you might have encountered errors where when a column has been modified, whether add or removed or renamed, the refresh is halted until. My usual fix is to download the PBIX and update source (Navigation) to…
-
Data Entry Suggestions for Siloing Data for Radar Chart
Hey everyone, I’m exploring the best way to use Smartsheet for collecting score card data and formatting it for a Radar Chart. Ideally, I’d like to: Enter audit results in Smartsheet Modify or structure the data in another sheet Format the combined data for visualization The goal is to merge audit percentages from the…
-
Merged: Connector for Smartsheet and Google Looker Studio
This discussion has been merged.
-
PowerBI "Failed After Multiple Retry Attempts"
Hi, I haven't seen this exact error on the forum, point me in the direction if I missed it. I have a Power Bi page running off Smartsheets data, nothing has changed in the past week apart from using Power Automate to schedule the Power Bi refresh. I don't believe this would have any affect. Since yesterday every time I try…
-
Merged: Internal Server Error w/ API PowerBI connection
This discussion has been merged.
-
Merged: Anyone having issues refreshing Smartsheet data in Power BI reports?
This discussion has been merged.
-
WorkApps and PowerBI?
Does WorkApps on SmartSheet integrate with PowerBI? I'm trying to take information from a sheet managed by another department that they shared with me that's on WorkApps, but when I go to "Get Data → SmartSheet (Legacy/Beta)" on PowerBI I see all the sheet I own or I'm shared to besides the ones within WorkApps. If not is…
-
Export PDF's Links from Latest Comments
Would it be possible to view the PDF's uploaded onto the Latest Comments Row? So far, when the data is exported into Power Bi, any PDF's attachement aren't viewable, as the URL for the attachments doesn't seem to be stored within the export. I would like to be able to view the SmartSheet attachments within Power BI, which…
-
Add Connectivity to Power Apps
In Power Apps, there looks to be a perisistent issue with connecting to SmartSheets and creating a form. This sadly means the Power Bi reports I have created cannot have Power App intergration, which would have allowed editing of SmartSheet data directly from Power Bi. Are their any planned workarounds for this?