cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBInewbie21
Helper I
Helper I

Data refresh error while refreshing a table in a report on Desktop

Hi, I had a working report on Desktop and Service. I went to refresh my report in desktop as no gateway is setup for the database. And I started showing me below error message. I login to SqlServer using my windows credentials. 

Can you find what is wrong here? 

I tried clear Permissions, Edit Permissions (Credentials type -Windows, Organizational Account, Encyption, Privacy Level etc) but nothing works. Is there any article on when to use which type?

The rows from the table on the report just disappears and never comes back when I hit refresh query. 

 

PBInewbie21_0-1611363301650.png

PBInewbie21_1-1611363335577.png

 

If I pick Encypt Connection then below pop up show up but in no ways data shows in my table.

PBInewbie21_2-1611363460346.png

 

Thanks !

 

5 REPLIES 5
vanessafvg
Super User I
Super User I

have you tried deleting and republishing?





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

Proud to be a Super User!




Thanks for your reply. I have not as problem is in desktop file. I need refreshed data and as soon as I refresh my table visual is totally blank. For now removed and added the source again which worked. I'm afraid about future when password changes again as I'm not able to setup refresh through gateway as I used Sharepoint Online. 

iXpert_info
Advocate I
Advocate I

Hey @PBInewbie21 
Can you please try using Microsoft or Database Credentials  instead of windows credentials?

Also I found a similar case as yours
https://community.powerbi.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-O...



Did I Answer your question? If Yes, Please mark my answer as solution

Best Regards
Jay Patel
iXpert Analytics

Thanks for your reply.

Yes, I tried changing all the options but my table on visual stays blank. I went and checked data in data table and see new data in there but no change on visual.

Thanks for the link to another question too. I see last comment says they ended up changeing the connection tpe to windows. I have same one. Bigger confusion is when do I use which connection type?

@PBInewbie21 

Here is an article about authentication types. In my understanding, the access limitation (if there is any) of every authentication type is determined by the data source side. Power BI plays a role as a client like other client tools used to connect to the data source.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.