Data loads in the Transformation View but not in the Table View

[mateusz_ta]

Hi,

I want to load a table from SQL Server. The data loads in the Transform Data view, thus, the query must work.

However, after applying changes, the loading starts and get stuck on "waiting for [server name/table name]".

I've already tried to delete the query and create the same query again, but it did not help.

Also, after publishing the dashboard, the visuals don't get updated with the new data.

How to make the table appear in the Table view? 

[v-nmadadi-msft]

Hi @mateusz_ta 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks

[v-nmadadi-msft]

Hi @mateusz_ta 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @mateusz_ta 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[mateusz_ta]

Any other potential ideas how to solve it?

[saritasw · Accepted solution]

@mateusz_ta ,
Try this - 

Delete the table from the Power BI model completely. Save and close the Power BI file. Reopen it and reconnect to SQL server. When adding the new table, use a slightly different name to avoid any internal conflicts. Limit rows in the query (TOP 1000) and see if the load works. Remove or exclude large/complex fields.
OR
Another possible reason could be SQL Server Permissions or Locking

Because the query runs fine in Power Query but hangs when loading to the model. This could be caused by row-level locks, blocking, or long-running transactions in SQL Server while Power BI tries to load all the data.

Try running the same SQL in SSMS with WITH (NOLOCK), or check for any active locks on the server.

[saritasw]

@mateusz_ta ,

There are several reasons this might happen. One common reason is that even if the data loads in Power Query, it won’t load into the model unless you tell it to.

Go to Transform Data, then in the Queries pane on the left, right-click your query and make sure "Enable Load" is checked.

If it’s unchecked, the table exists only in Power Query and won’t show up in the Table View or in visuals.
_____________________________________________________________________________________________________________________
If this solution worked for you, kindly mark it as Accept as Solution. This would be helpful for other members who may encounter similar issues and feel free to give a Kudos, it would be much appreciated!

Thank you,
Sarita 

[mateusz_ta]

The "Enable Load" has been checked. Still, it does not update.

[saritasw]

@mateusz_ta ,
Make sure your final table doesn’t depend on anything that isn’t loaded or fails during refresh. Also, check Power BI’s privacy settings:

Go to File > Options > Privacy, and set it to "Ignore" or "Combine data according to your Privacy Level settings". Then reload the data.

[mateusz_ta]

Changing the Privacy to "Ignore" did not help.

However, I tried to load different data from a different server and different database and it seems to work and the data is visible both in the Transform Data view and in the Table view. But with the original table and server it still does not work.