Power BI datasets Integrated Security=ClaimsToken

[Mrquestionmark]

I have a pbi desktop report using Power BI datasets to connect my PBI service dataset. It works on my PBI desktop but when I deployed it to my on-premise PBI server. The data source security pops error below. 

Couldn't connect

The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Hide error details 

The integrated security 'ClaimsToken' is not supported for native connections.

My quetion is:

Can I use Power BI datasets on-Premise to connect the dataset in PBI services? If it is doable, how to setup the security in data source?

Thanks in advance

[v-shex-msft · Accepted solution]

HI @Mrquestionmark ,

In fact, power bi service connector is linked with live connection mode, it requires you to keep the connection from your device to power bi service dataset.
After you move your pbix report file to a new device, you need to update your credentials and check network status and firewall policy to keep the power bi connections. (if your on-premise server not able to access to power bi service, you need to configure a proxy or other settings to fix connection issue)
Regards,

Xiaoxin Sheng

[Mrquestionmark]

Thanks Xiaoxin, I think you are right. We do have firewall policy setup in our server. I will discuss it with our InfoSec team.

One more question, what is the difference in service Sign In between PBI desktop On-Premise version and Cloud version? I can sign in using Cloud version but could not sign in using On-Premise version. It pops up "Your network requires proxy authentication." 

[Mrquestionmark]

@v-shex-msft 

Thanks Xiaoxin, I think you are right. We do have firewall policy setup in our server. I will discuss it with our InfoSec team.

One more question, what is the difference in service Sign In between PBI desktop On-Premise version and Cloud version? I can sign in using Cloud version but could not sign in using On-Premise version. It pops up "Your network requires proxy authentication." 

[v-shex-msft · Accepted solution]

Hi @Mrquestionmark ,

In fact, desktop sign-in operation only sends requests to power bi service side to verify if your account existed on the service side.
BTW, it will also be used when you connect to power bi service dataset. ( it will send sign-in user credentials as a token to get correspond dataset list)

Regards,

Xiaoxin Sheng

[v-shex-msft · Accepted solution]

HI @Mrquestionmark ,

In fact, power bi service connector is linked with live connection mode, it requires you to keep the connection from your device to power bi service dataset.
After you move your pbix report file to a new device, you need to update your credentials and check network status and firewall policy to keep the power bi connections. (if your on-premise server not able to access to power bi service, you need to configure a proxy or other settings to fix connection issue)
Regards,

Xiaoxin Sheng