Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
homboy27
Helper I
Helper I

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.

4 REPLIES 4
GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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. 

GilbertQ
Super User
Super User

Hi @homboy27 

 

That would be because you have blanks or null data in your Excel file. I would recommend in power query to replace those null values with a valid text value.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I am replacing them with a valid text value. Do you know why this keeps happening?

 

Also I have a file that I auto refresh and save on Shared Drive. That file on shared drive is then referenced when i refresh the BI report in the workspace. However when the BI report refreshes, it doesnt pick up the values in the file.  I have to manually open the file on Shared drive and resave and then refresh the BI report for it to pick the values from that file. Do you know why that might be?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors