Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Dataflows: Table are empty in PB Desktop

  • 1.  Dataflows: Table are empty in PB Desktop

    Posted 30 days ago

    Hi everyone,

    I've got a problem with Dataflows, I have created 3 dataflows:

    1. From Excel file: No problem at all
    2. From Template Dynamic 365 Sales: I have refreshed after creating and I've checked that there is data but when I tried with PB Desktop, it tells me that tables are empty. I have also refreshed the navigator.
    3. From SQL Server: I have refreshed after creating and I've checked that there is data but when I tried with PB Desktop, it tells me that tables are empty. I have also refreshed the navigator.
    Dataflow with Data
    Dataflow has data

    PowerBI Desktop

    Navigator tells me that tables are empty when they are not



    Can anyone help me what I am doing wrong?

    Thank you,

    Miguel Angel




    ------------------------------
    Miguel Angel Casares

    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: Dataflows: Table are empty in PB Desktop

    Top Contributor
    Posted 30 days ago
    Hi !

    It seems PBI Desktop is omitting NULL rows, please try some raw data other than NULL in your Dynamics & see if it starts getting populated into Power BI.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Dataflows: Table are empty in PB Desktop

    Posted 28 days ago
    Thank Hasham, I'll try and I let you know.

    Regards,

    ------------------------------
    Miguel Angel Casares
    +34 62 5709 809
    ------------------------------

    Conference-PBI_200x200