Forum Discussion

pranim's avatar
pranim
Icon for Helper I rankHelper 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 dri...
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,

pranim's avatar
pranim
Icon for Helper I rankHelper I
9 years ago

Thank you Zhang, screen shots are helpful. So far everthing i did looks good... but the link is giving me the problem. Once i get the correct link i am good to go, i suppose. I would not need a gateway too, is it?

 

Why did you choose to sign in with  'OAuth2' credentials... whats wrong with 'windows' sign in?

 

Thanks in advance 

 

Pranitha

 

 

Anonymous's avatar
Anonymous
Not applicable
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,