Unanswered

Export from Excel to PowerBi

(0) Share

Report

Posted on by AaronMcClay1311

Hello,

I am trying to figure out an easy way to export data from excel and put it into PowerBi. The "Add Rows to Dataset" action in Power Automate doesn't work. I have two SQL queries I have running into an excel sheet. They are pulling what we have shipped for the day from our 2 different databases. I have the them aggregating into one table to make it easier to digest and look at. What I am wanting to happen is after the day is done that table to get dumped into PowerBi dataset for further analysis.

Once I can get this figured out then I will dump the historical data in so we can have a year over year look at everything.

The only thing I can think of is to create a SharePoint list that the excel data fills in at the end of the day then updates the PowerBi dataset. That seems like a lot of extra work. Does anyone have any other ideas?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

GizzelleAkin 22 on at

Like (0)

Report
Copy link

Link copied!

Hi! Is connecting the Excel Dataset directly into Power BI and using that as a datasource vs adding those rows to your existing Dataset an option?

Was this reply helpful? Yes No
AaronMcClay1311 34 on at

Like (0)

Report
Copy link

Link copied!

I don't think so. The other issue I ran into is the fact the excel table has to be updated before I can use the data. I have to do a Desktop PowerAutomate to run to update the table then have it go into a SharePoint list then into the PowerBi. I can't write the SQL directly into PowerBi because it isn't on Prem and I haven't found a way around that yet.

Was this reply helpful? Yes No
GizzelleAkin 22 on at

Like (1)

Report
Copy link

Link copied!

I would try just feeding the Excel Document Directly into your Power BI Environment, then it would live update with your refreshes....let me know if you want to try it out and see if it works.

Was this reply helpful? Yes No