power bi is empty after loading data to power bi and there is not error in power query

[sudarshan08]

 

 

power bi is empty after loading data  to  power  bi  and there is not error in power query is good but not able to load the date to power bi and I am loading data to power query form system local hard disk it self 

[v-jtian-msft]

Hi@sudarshan08 I am glad to help you.
Hello,@foodd ,@SaiTejaTalasila,thanks for your concern about this issue.

If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sudarshan08]

My problem has not bee solved & what is the solution ? @v-jtian-msft 

[v-jtian-msft]

Hi,@sudarshan08 .I am glad to help you.

According to your description, when you load the same data source in Power BI Desktop on another computer, it shows up fine, but after loading the data on your own computer, power query doesn't report an error, but it also reports an error when you show only the column names in the table view without the specific data in visual.
This is very strange, here are my suggestions

1. check the data source connection, make sure the data source connection is normal, and there is no missing or modified data.
2. Have you tried refreshing the data. Please refresh the data source

3. Make sure your data type is correct. Because you mentioned that you can't load date type data, which is very strange, wrong data type may cause the data can't be displayed properly

4 Check your data connection method, is it import ,DirectQuery or connect AS model (import/live connections)
Based on the screenshot, I assume it's import mode, since you have all the functional interfaces on the left side (table view ,report view ,model view )

You can try to re-create a new test datasource: exclude the problematic date field, check if the other columns can be loaded properly and displayed in visual, check each query step in your Power Query to make sure that it works.

Since you mentioned that you are loading the data on someone else's computer without any problems, please double check that this is an isolated case and that it is only your computer that is loading the data source in question.
If you check and find that only your power BI desktop loads the data, the data will be empty.
Please try the following actions:
1. Please try to clear the data cache of Power BI Dektop first.

2. check if you currently have enough permissions to access the data source (you can check this by logging into your power bi account in the desktop app of another user's computer to see if the problem is due to insufficient access to your account)
3. Check your firewall and system settings to see if there are any sensitive settings that are causing compatibility issues with your current data source.
4. If the above operations you have tried have not worked. Please re-download the latest version of Power BI desktop (please make a good data backup in advance to avoid loss of data) and ensure that there is no interference from the residual information in the registry (clean up registry information).

If possible, please provide screenshots of the relevant operations, which will help to solve your problem.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SaiTejaTalasila]

Hi @sudarshan08 ,

Open transform data and check your applied steps one by one .May be your transformation steps are blocking the data or there is no data on source or it is pointed the wrong source.

Thanks,

Sai Teja 

Thanks,

Sai Teja 

[sudarshan08]

Hi @SaiTejaTalasila 
I checked  form other laptop I am able to load the data  and see the data on power bi there was no issue at all with data which I transformed how do I contact you please help me 

[foodd]

Hello @sudarshan08 , remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!