Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More

Memberships

Learn Microsoft Fabric

14.5k members • Free

7 contributions to Learn Microsoft Fabric
Date Time values automatically Changing
I’m fetching data from Salesforce and storing it in a Lakehouse using a data pipeline. However, after the data is stored in the Lakehouse, I’ve noticed that the values in the DateTime-type columns are shifted—specifically, the timestamps are 4 hours ahead compared to the source data in Salesforce. During my investigation, I’m wondering: does Microsoft Fabric automatically convert DateTime values to a specific time zone? Based on my analysis, the 4-hour difference aligns with the time zone offset between UTC and EDT. Although Salesforce operates in the EDT time zone, it stores and processes DateTime values internally in UTC. If anyone has encountered a similar issue, I’d appreciate it if you could reach out or share your insights. Thanks!!
0 likes • Sep 2
from_utc_timestamp(current_timestamp(), 'Asia/Dubai') you can convert accordingly.
Lakehouse Schema - help required
Hi All, I have created a schema in Lakehouse and loaded the data into it using a pipeline. --> In Lakehouse view : all the tables are created like schema --> In SQL EndPoint : all the new tables are moved under dbo schema. any help/suggestions to fix this and move the tables to newly created schema. Pipeline: lakehouse SqlEP
Lakehouse Schema - help required
0 likes • Oct '24
@Will Needham
0 likes • Oct '24
@Bertalan Ronai ; just tried now and I'm facing the same issue
NB Issue writing to delta, help!
Ive had this issue on an off for a while and cant figure it out, ive tried using: df.write.format("delta").mode.("overwrite").save("File/path") and I get the result in the Screen shot. When I use .SaveAsTable, I get an error. cant figure it out! Surely writing as a delta either works or it doesnt, I still get a delta log and a parquet, but its like its not recognised?? has anyone come across this and know more from the error response? bonus question, where do you go for diagnosing errors? thanks!
NB Issue writing to delta, help!
1 like • Sep '24
I came across this issue and altering the table properties (via notebook) resolved the issue. ALTER TABLE table_name SET TBLPROPERTIES ( 'delta.columnMapping.mode' = 'name', 'delta.minReaderVersion' = '2', 'delta.minWriterVersion' = '5') check for the exact error and update your table properties
PowerBI Report Sharing
Hi There. Is there a way to share my powerbi report with users in my company that do not have powerbi pro lic like for them to view the report i'm sharing? If so how? How can Power Automate or SSIS help?
0 likes • Aug '24
@Tumelo Tsikana you can use the PowerBi Embeded report and restrict the access using the RLS.
DP-600 cleared
Cleared the certification! The community here was a huge help. Thanks for creating this, Will! I'm excited to learn more advanced scenarios and contribute to the community.
0 likes • Jul '24
@Jordan Lazarus thanks
1-7 of 7
Sairam K
2
5points to level up
@sairam-k-8705
Data Engineer building next enterprise data environment using fabric

Active 91d ago
Joined May 23, 2024
Dubai
Powered by