Problem with Date column and One Drive source.

Hi Anonymous 

In the second way, when connecting to Power BI dataset with Power BI Desktop, since this is a live connection, left-navigation and modeling are disabled, similar to the behavior when connected to SQL Server Analysis Services.

More explaination here:

https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasets#limitations-and-considerations

In the first way, since you connect to on-premises folder,you need to add this data source under a gateway.

References how to install gateway and configure schedule refresh are as below:

https://docs.microsoft.com/en-us/power-bi/service-gateway-install

https://docs.microsoft.com/en-us/power-bi/service-gateway-manage

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.