Smartsheet dataset in Power BI

Kevin Smith

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

Genevieve P.

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