I am following the recommended process to get data from a .xlsx file on SharePoint into Microsoft fabric using Dataflow Gen2.
- I have created a lakehouse
- I used Dataflow Gen2 and connect to SharePoint
- I used the Dataflow to process the data
- I selected the Lakehouse created as the target
- Publish and refresh the dataflow.
- I can see the data in lakehouse
- I can use SQL endpoint to write queries using SQL
- If i use the SQL endpoint to create a PowerBI report (DQ or import) it works.
However the Power BI report using Lakehouse refuses to update any visuals with numbers (Floats).
I am not sure what is wrong. Please help with possible solutions.