Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello.
I can get data and I can edit this. But I cannot aplly the data into the data model.
The next print show the data in Power Query .
The next print show the data when I apply the data to the data model.
There are no data in the table.
Can you help me!
Thanks.
Hi Allan!
I am very grateful for your help, but I have not more time.
I am attemping get the data by another way.
Thank.
Fernando.
Hi, @fjara
Based on your description, there is no data in Power Query after the refresh. I wonder if you have made some changes in earlier steps like filtering rows. You may try creating a new query and apply the same transformations to the data source to see if it works.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think that is saying there is no column with that name to filter, so perhaps you renamed in an earlier step but didn't redo the filter subsequntly applies. I cannot be sure, and I cannot paste that error into a translator.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI've seen this behavior before and can't explain it. When you pull down one of the column filters, do you see data values there (the arrow at the top of each column)? When I see this, if I filter on something, the filtered table shows up.
Also, you should promote your first row to become the headers.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Yes, I can see values.
I have selected "Desborde SUBE NSSA" in column1.
Then I promote te columns names and select a different value in column "CAMPAÑA" ("Piloto SUBE").
I can see all values.
A question: The url is not "https". Is this relevant?
Sorry.
Now, I refresh previous view and send the follwing msg.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHello Edhans,
1. No errors when loading.
2. When I back to Power Query editor and refresh, the table is empty, like you can see y the next screen.
3. I can show you the table in the navigator.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.