Forum Discussion

PBInewbie21's avatar
PBInewbie21
Helper II
5 years ago

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 u...
Need Help
PBInewbie21's avatar
PBInewbie21
Helper II
5 years ago

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?

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    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.