cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
goaltender36 Regular Visitor
Regular Visitor

data refresh in power BI on report built in Desktop

Hello,

 

So I am having an issue with refreshing my data in Power BI.

 

My data is stored in Azure SQL from an Access Web App. I pulled the data and generated a report in the Desktop then published it to a workgroup. When I go to Power BI online and hit refresh to see new data I get an error saying my refresh failed.

 

Any thoughts? Am I doing ths right?

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: data refresh in power BI on report built in Desktop

Hi @goaltender36,

 

Sorry for slow response, I think the issue may related to dataset, you can check its connection state at "Setting" -> "Datasets".

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

7 REPLIES 7
Super User
Super User

Re: data refresh in power BI on report built in Desktop

What is your error saying?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

goaltender36 Regular Visitor
Regular Visitor

Re: data refresh in power BI on report built in Desktop

Thank you for your help on this.

 

This was the error:

 

Data source error:
Unable to cast object of type 'ComDataConvert' to type 'ComDataConvert'.. The exception was raised by the IDataReader interface.

  

Do you think it could because I did an import from the Azure SQL DB instead of DirectQuery?

Super User
Super User

Re: data refresh in power BI on report built in Desktop

Hi @goaltender36, it would appear that there is a possible data type change in one of the columns? Where potentially it was a Whole Number, and now that particular column has a text value, causing the Whole Number data type to be invalidated or wrong?

 

It is a guess but something to look at.

 

Has the data ever been able to refresh successfully?


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Community Support Team
Community Support Team

Re: data refresh in power BI on report built in Desktop

Hi @goaltender36,


Can you share us some detail information to help us to reproduce your issue?

 

For example: Publish steps, screenshots, detail error log, refresh type, dataset connect state...

 

Regards,
Xiaoxin sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
goaltender36 Regular Visitor
Regular Visitor

Re: data refresh in power BI on report built in Desktop

Hey @GilbertQ I tried yesterday reconnecting as a Direct Query and I think that worked. I haven't gotten the error since even after entering new data into the Access Web App and then clicking refresh.

goaltender36 Regular Visitor
Regular Visitor

Re: data refresh in power BI on report built in Desktop

Hey @v-shex-msft

 

I built an Access Web App on a SharePoint and then opened Power BI Desktop and did an Import of the data, created some visuals and published it to a WorkGroup I created in Power BI. (It was when I refreshed the data source online in Power BI I got the error)

 

I then created a new connecting in Power BI Desktop and this time as DirectQuery and then uploaded to the workgroup. Now I do not get the error.

 

Is this because of where the data is being queried?

 

Community Support Team
Community Support Team

Re: data refresh in power BI on report built in Desktop

Hi @goaltender36,

 

Sorry for slow response, I think the issue may related to dataset, you can check its connection state at "Setting" -> "Datasets".

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 388 members 3,346 guests
Please welcome our newest community members: