Pull Data from Power Bi to Smartsheet

YBnf

Hi,

I would like to integrate Power bi with Smartsheet and pull the data on the tables on Power bi to Smartsheet.

Is there a way to make this connection ?

The reason i need to do this is to make my employee see the data through Smartsheet not from Power bi.

Thank you.

Genevieve P.

Hi @YBnf

One way to get the data into Smartsheet would be to Export your Power BI data into an excel file, see: Export the data that was used to create a visualization

Then you can import that into Smartsheet to create a new sheet, or if you have access to Data Shuttle, automatically bring that content into a current sheet.

I hope that helps!

Cheers,

Genevieve

jprovo227

**Sorry, just realized that you wanted the other way around - and I cannot delete the comment.**

There is now a Smartsheet connector in Power BI. If you go to "Get Data" and search for 'Smartsheet' you will see a Beta connector for the Smartsheet application. Assuming you have Admin permissions, you should be able to pull data from sheets and reports into Power BI.

This has been working successfully for me regarding Row Reports, however I am having issues importing data from Sheet Summary Reports. I just submitted a ticket with Smartsheet to review

Power BI - Smartsheet Successful Row Report Data.PNG

.