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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PBInewbie21
Helper II
Helper II

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
Super User

have you tried deleting and republishing?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

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
Helper II
Helper II

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.