Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PhilSmith
Helper I
Helper I

Redo Credentials every three months? WHY?

Hey Folks, does this really happen to everyone?  Tech support seems oblivious.

 

I have a lot of spreadsheets,  that are updated or reguarly created by various processes, such as Microsoft Access.    I have these sitting in a PowerBI folder in one drive, for cosumption by PowerBI.  For instance, I link to my date table with something like:

Source = Excel.Workbook(Web.Contents("https://domain.sharepoint.com/sites/MyLibrary/Shared%20Documents/PowerBIFiles/Date.xlsx

 

Every three months, ALL of my Datasets, (now called "Semantic Models, " really Microsoft?)  fail with credential errors.  None of the credentials have changed, but every single file hosted in one drive has to have it's credentials reset.

I have to believe that grabbing spreadsheet data from Onedrive is common practice, and I don't see how everyone has this issue, but NO-ONE at any level of tech support has heard of the problem.  Wouldn't it be right in the 1st tier support docs if it was just always the case when accessing one drive files?

 

Is it just the way it is, or is there something I can do to stop it?

 

Thanx

 

Phil

4 REPLIES 4
GilbertQ
Super User
Super User

Hi @PhilSmith 


Could you chat to your network admin as they might have a setting for your account that it has to log in again every 90 days?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I am one of the admins.  All of the admins have all been all over it, along with Tier 2 assistance.  What we are being told by MS is that when you set up the credentials, it creates temporary tokens.  There a couple of settings that are supposed to create tokens that last a year, but acccording to TS, these parrticular tokens expire in 90 days, regardless.  Again, if this is the way it is, loads of folks would have this problem, and TS would know, but they don't.

I have not experienced this. I would have said like @GilbertQ that it is some conditional access policy.

You say you have not expereinced it.  You do access files from Onedrive into your Datasets?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors