Forum Discussion
One Direct Lake (OneLake) table is empty despite data in warehouse
New data was inserted with a SELECT from a view and there was an error that was introduced in the view. After fixing the view and truncating/inserting new data into the table, Power BI showed data. The other issue was that a MERGE statement was used which isn't supported in fabric. Either one of those two things must have caused the issues. It is now resolved, however.
Community Champion- Check and convert unsupported types; rename columns to simple names.
- Add a unique ID column if missing.
- Refresh metadata in Desktop (remove & re-add table).
- Ensure OneLake storage permissions are correct.
- If needed, create a SQL view with clean columns and use that.
Hi Shahid12523
- data types are supported and there is no mismatch between warehouse and semantic model
- regarding unique column ID, renaming to simple names and creating a SQL View: up until yesterday, the report worked fine even without a unique column ID and the current names
- refreshing metadata doesn't change anything
- onelake storage permissions are correct because i can see the data when i use SELECT statements in the SQL endpoint
- creating a sql view wouldn't work because they need to be materialized for direct lake and I believe it's a preview feature for warehouses
Hi Anonymous ,
As none of the troubleshooting steps seemed to work, please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you