Forum Discussion

homboy27's avatar
homboy27
Icon for Helper III rankHelper III
2 years ago

Power BI recognizing Null data

I am referencing a excel file from the Shared drive for a report I am refreshing in workspace. But the file keeps pulling in null values. Do you know why? I have formatted the data as a table as well...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
2 years ago

Hi homboy27 

 

You will need to use the Power BI Gateway to create a data source connection to the file so that it is included when you refresh your semantic model.

  • homboy27's avatar
    homboy27
    Icon for Helper III rankHelper III
    2 years ago

    Thanks for the reply. I already have used the POWER BI gateway for this so the file is included with the refresh that I do.