Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Data source error

I would like to load data from Google Analytics into Power BI. After transforming the data in the Query Editor, I apply the changes. At first, I see the message 'Waiting for www.googleapis.com' and the number of rows increases. After a while, I get the following error message:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] There was an internal error..'

 

How can I solve this error?

I am a new member thanks for understanding!!!

 

Thank you in advance 

1 ACCEPTED SOLUTION
DataVitalizer
Super User
Super User

Hi @Anonymous 
For each table, try checking the data types of your columns then refresh only the selected table.

 

Did it work ? 👌 Mark it as a solution to help spreading knowledge  👍 A kudos would be appreciated

View solution in original post

4 REPLIES 4
ReportGuru
Post Patron
Post Patron

Hi. As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA connector in the data sources list:

 

GA-1.png

 

After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:

 

GA-2.png

 

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.

 

SELECT_DESTINATION_NEW.png

v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

First go to edit query and verify the data types and change the data types if needed, after that if you still facing this error, you need to keep open the app.powerbi.com while refresh your PBI dashboard.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DataVitalizer
Super User
Super User

Hi @Anonymous 
For each table, try checking the data types of your columns then refresh only the selected table.

 

Did it work ? 👌 Mark it as a solution to help spreading knowledge  👍 A kudos would be appreciated

Anonymous
Not applicable

Hi @DataVitalizer @v-stephen-msft problem was indeed the data types. I retreive some data from GA while a column have both numbers and <no set> values, while i remove the <no set> values and change the datatype everything was working fine. Btw do you have any reasoning why this <no set> values coming or  is a problem in the data it self?

 

Thank you for your prompt response 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.