Smartsheet dataset in Power BI
Hi
I have connected the Smartsheet App from Power BI and I can see my usage (users, access, groups, etc. - Admin stuff) but I cannot find sheets/reports/workspaces, etc. Have I missed something in how I set up my App? Do these things only show up if you are using Power BI Desktop?
Any advice would be greatly appreciated. Thank you
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
Answers
-
Hi @Kevin Smith
Yes, you will need to download the desktop connector from the Power BI website. See the "How to Get It" section on this page: https://www.smartsheet.com/marketplace/apps/microsoft-power-bi
Here's the Microsoft Documentation on connecting Smartsheet with Power BI. It notes this:
"The Smartsheet template app for Power BI provides a dashboard, reports, and dataset that show an overview of your Smartsheet account.
You can also use Power BI Desktop to connect directly to individual sheets in your account."
Cheers!
Genevieve
