Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

rdnguyen

Power BI Desktop Loading data issue

Submitted by Helper V on ‎08-10-2022 08:43 AM

Hi there,

 

I am currently experienced issue with Power BI Desktop Loading data from Dataflow.

The column h_WC-combine is created in Dataflow online which is the concatenation of two other columns. When loading data to the Power BI Desktop, some (not all) data of this column returned blank, despite the fact that both source columns has data or non-null. 

I went back to Dataflow and check, the exact record on Dataflow showing value, but Power BI Desktop did not. 

Then I created a new custom column concatenate the same 2 source columns in the Transform - Power Query Editor, result return correct, which confused me even more of why data was load from the Dataflow was process differently?

 

Could you please advise?

rdnguyen_1-1660146044138.png

 

 

Status: Investigating
See more ideas labeled with:
5 Comments (5 New)
Comments
TheShy
New Member
‎08-10-2022 10:44 PM

Hi @rdnguyen ,

 

 

You may try After creating the new dataflow, you may refresh the Dataflow on Power BI Service to make data loaded into the entity. Then, click the "Refresh" button in "Navigator" pane when use Power BI dataflows connector in Power BI Desktop . If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

 

This may not be exactly the same problem you're having, but I thought it might be worth a try to see if it would work as a workaround.

For original post, you can see Cannot load data from dataflow to Power Bi Desktop 

Anonymous
Not applicable
‎08-16-2022 11:02 PM

Kindly see the comments below

rdnguyen
Helper V
Helper V
‎08-17-2022 07:41 AM

@Anonymous , what does it mean by the status "delivered" as I found nothing related in the data modeling section matching my issue submission for review?

 

Again, from my test, I created a new column, change column name in dataflow, everything is updated to Power BI Desktop when connected, except that calculated column created in Dataflow (working fine in dataflow).

 

Please review my request or kindly help by pointing me to the existing request / issue reported so I could vote for improvement.

Anonymous
Not applicable
‎08-30-2022 11:41 PM

Hi @rdnguyen ,

 

I have modified the status of this issue to be able to discuss it better. I mistakenly understood that his reply was helpful to you. Sorry for the inconvenience.

 

 

rdnguyen
Helper V
Helper V
‎08-31-2022 06:34 AM

Thanks @Anonymous  for your support.

Idea Statuses