Forum Discussion

pranim's avatar
pranim
Helper I
9 years ago
Solved

desktop file save in power bi

HI All,

 

Please help me . I created the data in excel file and saved to sharepoint online. I could pull the data to power bi and generate reports but now, when i want to save the file into one drive, it is not allowing me to. Not sure where i am going wrong?

 

when i see from the file folder it shows the file has been uploaded to folder in onedrive... but actually when i open the one drive i see no files there. 

 

Please help me with this

 

Thanks in advance!

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    pranim,

    I test the scenario as yours, everything works well. After uploading the PBIX file to OneDrive For Business and connect to the PBIX file in Power BI Service, to schedule refresh for your dataset, you would need to enter the same credential as that you use in Power BI Desktop to connect to SharePoint Folder, you can review the screenshots in my environment.



    Regards,
    Lydia Zhang

  • Anonymous's avatar
    Anonymous
    9 years ago

    pranim,

    Gateway is not required when you connect to Excel stored in SharePoint Online and refresh the dataset.

    And Windows auth type is used when you connect to on-premises SharePoint. OAuth2 type is used when connecting to SharePoint Online.

    Regards,

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Not sure I follow you on this one. You uploaded your file to SharePoint Online (not OneDrive?) You pulled the data into Power BI (how?). you want to save to OneDrive but it is not allowing you. What is not allowing you? Desktop, Service? 

    • pranim's avatar
      pranim
      Helper I
      9 years ago

      Hi,

       

      Sorry for not being clear, I am new using power Bi. I will go by steps

       

      1. I entered the data manually onto Share point online excel sheets and saved it in share point online.
      2. From power bi desktop I have connected to share point folders and pulled the excel sheet I created
      3. From the pulled data, Created reports in Power bi desktop
      4. Now, I would like to save the  reports onto Onedrive and import the reports onto power Bi service from onedrive. So that I could schedule the dataset.
      5. To schedule the data set its showing me error.  it says that i don't have data source credentials for scheduling. What is data source credentials? How do I get that? 

       

      The overall thing is, I want to schedule the data set in power Bi services and from online material I learnt that, it can be done by saving the desktop files online and importing onto the power bi services.

      Please educate me if I am missing or not following the process correctly

       

      Thanks

      Pranitha

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        pranim,

        I test the scenario as yours, everything works well. After uploading the PBIX file to OneDrive For Business and connect to the PBIX file in Power BI Service, to schedule refresh for your dataset, you would need to enter the same credential as that you use in Power BI Desktop to connect to SharePoint Folder, you can review the screenshots in my environment.



        Regards,
        Lydia Zhang