Using the service with a data source that's an Excel workbook posted on my company's OneDrive.
It's been working like a charm ... except for hyperlinks. They are not clickable. I did the research and stumbled onto using PowerPivot to set the column to a data category of "Web URL (Suggested)." However, upon saving the file and refreshing the data set, this still results in standard text that is not clickable. I've searched the community listings but did not see a solution.
Any help would be greatly appreciated.