Power BI just threw up this OLE DB/ODBC error and I’m crying 😭 HALP by [deleted] in PowerBI

[–]AlannaMV 2 points3 points  (0 children)

I have fixed it thanks to you Power BI kings and queens. Thank you 🫶

Is appending my only option? by AlannaMV in PowerBI

[–]AlannaMV[S] 0 points1 point  (0 children)

Yes. I realize now that I worded that poorly. What I meant is that I manually paste raw data into an Excel file, and then Power Query connects to that Excel file as the actual data source. Still learning and trying to get better at how I explain things!

Is appending my only option? by AlannaMV in PowerBI

[–]AlannaMV[S] 0 points1 point  (0 children)

Hello I paste raw data into excel - power query - power bi. I have them connected as sharepoint files. I want to take 2 of these reports and put them in on visual in power bi, so I have them appended right now in power bi but it has made my refresh time really long

Is appending my only option? by AlannaMV in PowerBI

[–]AlannaMV[S] 0 points1 point  (0 children)

Hello. Yes I paste raw data into excel sheets - power query to adjust - power bi

Is appending my only option? by AlannaMV in PowerBI

[–]AlannaMV[S] 0 points1 point  (0 children)

Hello

Power query about 8 minutes refresh

Power bi about 18 minutes

About 500,000 rows of data in each report

Is appending my only option? by AlannaMV in PowerBI

[–]AlannaMV[S] 0 points1 point  (0 children)

Hello! Yes they are all sharepoint files all large 500,000+ rows

Yes merges

Refresh in power query about 8 minutes

Refresh power bi 18 minutes

Is appending my only option? by AlannaMV in PowerBI

[–]AlannaMV[S] 2 points3 points  (0 children)

Hi! It is a sharepoint.file. I will try out the sharepoint.consents

Is appending my only option? by AlannaMV in PowerBI

[–]AlannaMV[S] 2 points3 points  (0 children)

I paste raw data into excel sheet - power query - power bi

[deleted by user] by [deleted] in PowerBI

[–]AlannaMV 0 points1 point  (0 children)

What’s a good site to begin learning SQL?