Forum Discussion

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
7 years ago

Error Connecting to Power BI Dataset from Power BI Desktop

Hello,

 

I have an on prem SQL server which we're connecting to via gateway. In order to make use of the native security logic that already exists in our database I've checked "Use SSO via Kerebos".

 

I've then created a dataset fine using direct query mode and published it to PowerBI service.

 

If I create a new report based on the dataset online it works fine however if I do it from PowerBI desktop it connects fine but then all visuals give the error:

 

COM error: Microsoft.Cloud.Platform; 'userPuid' may not be null or empty in method 'Microsoft.PowerBI.DataAccess.dll!Microsoft.PowerBI.DataAccess.PowerBIDatabaseUsersHelper+<TryGetUserByPuid>d__19.MoveNext' (MoveNext at offset 142 in file:line:column <filename unknown>:0:0

)

Parameter name: userPuid.

 

I'm guessing it's something to do with the Kerbos authentication of going from a domain machine up to the cloud and back out but don't know where to start looking.

 

Thanks in advance,

 

Ben

Need Help

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi bcdobbs ,

    I'm a little confused about your scenaio.

    If I create a new report based on the dataset online it works fine however if I do it from PowerBI desktop it connects fine but then all visuals give the error:

    Do you have this issue with the Power bi dataset connector in power bi desktop?

    If so, please check if the gateway works as expected. 

    Best Regards,

    Cherry

    • bcdobbs's avatar
      bcdobbs
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Hi v-piga-msft,

       

      We have a number of reports that I would like to use the same dataset for.

       

      Process:

      1) Used Power BI Desktop to create a blank report which just contained a data model connected to an on premise SQL server.

      2) Published to PowerBI Online. The gateway detected it fine and I set it to use Kerbos authentication as all our security is built into the sql server.

      3) Creating a report in powerbi online using this dataset then works fine. It refreshes and users only see what they should do.

      4) I would however like to be able to create new reports in Power BI desktop pointed at the PowerBi Online model that was created in step 2. When I do this all the visuals give the previously mentioned error.

       

      Is there a better way to achieve what I'm doing?

       

      Hope that makes sense.

       

      Ben