Forum Discussion

gterrasi's avatar
gterrasi
New Member
6 years ago

Report update on dataset update

I choose a file uploaded on OneDrive as dataset for one of my reports. I updated the file on OneDrive and then clicked on "update" on the dataset, but the report won't update with the new informatio...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

gterrasi 

What type of file are you using?

 

What connector did you use to import your data into Power BI?

 

I've used Excel spreadsheets in OneDrive by opening them up in full Excel, I've then opened up a blank worksheet as well.

In my blank worksheet I select any cell, type = and then click in any cell in the OneDrive sheet.

 

I've then closed the OneDrive sheet, which leaves me the full web address in the blank worksheet.

 

This address (minus any sheet name and cell references) can be put into the 'Web' connector in Power BI.

 

Hope that helps.

gterrasi's avatar
gterrasi
New Member
6 years ago

hi, Anonymous I'm not sure I really understood your instructions.

BTW, I also need to publish the site on the web but to protect the url with password.

Is that possibile?

 

thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi gterrasi 

     

    In your original request you said your data source for Power BI is a file in your OneDrive. What type of file is it? This will help get you the right information.

     

    Published Power BI reports are subject to the viewer also having a licence, so wherever you share the report, the recipient must also have a licence. You can bypass this by using Publish to Web, but then anyone can view your report, so unless it is already public data, that's probably not going to help you out. Password protection is not something you can put on a published Power BI report.