Forum Discussion

Cpgbi's avatar
Cpgbi
Regular Visitor
6 years ago

Data source **** is missing credentials...

When one of the three of us on PBI Pro uses desktop to publish a report we can’t access it, including the creator. But if the report is emailed to me I can publish it just fine. In app.powerbi I can go to the dataset and “take over” and then everything is fine. The creator sees a message saying it can’t be refreshed because the credentials are invalid when going into app.powerbi to see the dataset. It feel like blowing away her account and then recreating it and starting over. Any thoughts?
Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    Sign in https://msit.powerbi.com/home sign in go to your account. In My account go to dataset tab (Left side of your screen to you the tabs) select your Dataset https://msit.powerbi.com/datahub/datasets (Select the dataset that your facing this error) from it -- Pick the data set from the list and sign in with your credentials and refresh it and check now it will work 100% and you can able to see the report yours as expected
     
    Thank you!
    Venkata Teja Bathala
  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Cpgbi 

     

    What do you mean" But if the report is emailed to me I can publish it just fine", Not quite understand your scenario, could you please share more details with screenshots?

     

     

    • Cpgbi's avatar
      Cpgbi
      Regular Visitor
      6 years ago
      Screenshots I cannot post unfortunately. What happens is one of the three of us with a PBI Pro login and has access to the particular workspace can download, edit, etc. she gets the data source error when publishing. But if she sends to me and I open and publish it works fine. I compared settings everywhere I could find and it seems everything is exactly the same. But there has to be a setting I’m unaware of that is stripping the credentials when she publishes. So this is different than the similar error people have seen regarding refreshes.
      • v-diye-msft's avatar
        v-diye-msft
        Community Support
        6 years ago

        Hi Cpgbi 

         

        1. If publish from the Desktop is not working, try to connect to the data from the Power BI Site. 

        Get Data -> Files (Get) -> Local Files -> find your PBIX file on local drive.

        2.   Make sure she has the role of power bi service administrator. you can check it in 365 admin portal.

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Cpgbi 

     

    I came up with new thoughts about this question, you mentioned that "it can’t be refreshed because the credentials are invalid when going into app.powerbi to see the dataset", the error typically happens when the credentials of the dataset been changed. 

    You can do a test on the desktop, connect to the data source and manually refresh it, if it failed, please clear the datasource setting and relogin. 

     

    If it still doesn't work, please kindly share the error details when "she gets the data source error when publishing."