cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.