The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
My data is showing in Power Query but when loading data to desktop, it's blank.
Not too sure what to do or check. (been using PowerBI for 2 years now, never had this issue). I checked all datatypes of my merges (if this was an issue the data in PowerQuery would be blank too I guess), .. any other ideas?
Thanks guys! Printscreens below.
M.
See printscreens below..
Power Query - Column "Exchange Rate" has data"
After loading data to Desktop, no data is shown
Hi @micds ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
Best Regards
Hi @micds ,
First, please make sure you have applied the changes in Power Query Editor and load them into Power BI Desktop by selecting Close & Apply from the Home tab of the ribbon.
After that, it seems there are 156 queries from the screenshot you provided. Which query (table) is having this problem? Could you please share the applied codes in in the Advanced Editor for the corresponding query? Later, we will make troubleshooting to check if a certain step was applied to cause such a problem.
In addition, please check the following links with similar problems to yours. Hopefully the solutions there will also help you solve your problem. Thank you.
Data loads in Power Query but not in Power BI
Best Regards
It seems to be a relationship problem. Are you using columns from different tables in your visual on desktop? If yes, check the relationship between these tables. Try to change the relationship type and/or filter direction.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
81 | |
81 | |
48 | |
41 |
User | Count |
---|---|
149 | |
110 | |
66 | |
64 | |
56 |