Forum Discussion
Convert Month text to Date
Anonymous
Thank you. I was unable to find a way to do this so I went about it the difficult way. I resturctured my Power App to use dates rather than just the text of the month name and then went back and changed all the old data into dates as well.
Thank you for your time and help with this issues.
Hi StephenGW,
You mentioned you are working with 'live connection' to these files. What type of data connector are you worked? How did you link to these files? Can you please share more detail about these?
AFAIK, power bi also allows you to use a web connector to link to the file stored in onedrive or sharepoint. It will keep edit features and allow you to do more data model operations.
Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
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,
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
Anonymous
Thank you for the great help and information! This is a great community of helpful people.