Cannot create a report from Microsoft Fabric Lakehouse when getting data using DataflowGen2 from .xlsx file in SharePoint

Asit Trivedi 0 Reputation points
2023-07-17T06:13:33.21+00:00

Hi there

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.

results:

  • 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.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,113 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 23,686 Reputation points Microsoft Employee
    2023-07-17T20:13:58.3666667+00:00

    Hello Asit Trivedi,

    Thanks for the question and using the MS Q&A platform.

    MS Fabric is currently not supported in the Q&A forums, the supported products are listed over Here  Supported products on MS Q&A (more to be added later on).

    You can ask the experts in the dedicated MS Fabric community forum.

    MS Fabric community: https://community.fabric.microsoft.com/t5/General-Discussion/bd-p/ac_generaldiscussion

    I hope this helps.

    0 comments No comments