Forum Discussion

StephenGW's avatar
StephenGW
Helper II
5 years ago

Convert Month text to Date

I have a line chart that goes by months. The problem is the months are full month text January, February, ect. The data is linked to an Excel file in my OneDrive so there are no tables in my Power BI...
Need Help
StephenGW's avatar
StephenGW
Helper II
5 years ago

Anonymous 

 

That is a great link. I did not know about this option. I linked it through Get Data>Files>OneDrive for Business>Import. My question with the method mentioned in the link, how does that work with sharing? In order to share with everyone in my organization I had to put both the report and dataset in the preimum workspace as some users are free. Since the data will remain in my OneDrive and not in the premium workspace will it still allow me to share?

 

Thanks,

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI StephenGW,

In fact, this mode does not affect the share feature usage.
Your report contents will be updated based on your credentials and work well with the users you shared. (Notice: don't forget to verify the data set credentials on the power bi side to enable the auto-refresh for these contents)

Data refresh in Power BI - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng

  • StephenGW's avatar
    StephenGW
    Helper II
    5 years ago

    Anonymous 

     

    Thank you for the great help and information! This is a great community of helpful people.