SQL throwing blank data into Power BI models despite thorough troubleshooting on both sides.

[TGameson2024]

Hello,

I use SQL server to connect our data to our Power BI models.  There has not been a problem before but it just the SQL packages just started throwing blank data. Yes, I can reproduce it every time.  Yes, I have conducted all troubleshooting with regard to data/reports, creating new SQL packages, reviewing the Power BI models and coding. There is nothing that I am aware of that has changed, not the data/reports, columns or our model in SQL or Power BI. There is no error message to screenshot because the SQL package runs fine and the Power BI refresh runs fine.  Once I refresh the SQL upload in Power BI the data uploaded is blank. Then the visuals are no longer working due to data being blank.  In addition, I walked through all the troubleshooting steps multiple times and continue to get the same results.  It leads me back to the facts, the data is correct and what Power BI expects to see when it is uploaded to SQL but when it is refreshed in Power BI it is blank.  Something between SQL and Power BI is at issue. Any ideas on how I can get the data in from SQL or why the data continue to come in blank?

TGameson2024

[TGameson2024 · Accepted solution]

This issue has been resolved.  The solution was the file name of the package set up in SQL must be identical to the table name that Power BI is expecting to receive.  Once I ensured they were named exactly the same, the issue was resolved. 

[v-shex-msft]

Hi @TGameson2024 ,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng