cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DataGuy2016 Regular Visitor
Regular Visitor

Re: Add an extra field from a data source

Beware - you will need a PRO license for every user who wants to view your data.

dan_hoff Regular Visitor
Regular Visitor

Re: Add an extra field from a data source

mine are all CSV and the above two methods work 100% fine;  if you cannot follow the steps, do you want me to do pics one by one.... that will cost me a bit of time, but I dont want you to be flummoxed;  for CSV it works a charm

DavidB Frequent Visitor
Frequent Visitor

Re: Add an extra field from a data source

Thank you for this, @reneincer
I am new to Power BI, and it was driving me crazy that I had to make things all over again if I wanted to add data to my data source.

SNV Regular Visitor
Regular Visitor

Re: Add an extra field from a data source

I also have the same problem as the topic starter.

 

Both the proposed solutions work for me, changing the column amount in the advanced editor and switching the source to automatic.

 

But is there a possibility to make the number of the amount of columns in the advanced editor a variable?

So before the data is imported, the columns are counted in the source, stored as a variable and then with the import source step the variable is put after the columns

 

Ex.  [Delimiter=";", Columns=X, Encoding=1252, Quotestyle=Quotestyle.None]),

 

Where X is the counted variable.

 

Maybe this could automate the 2 solutions, if it is possible

Pandreoni Frequent Visitor
Frequent Visitor

Re: Add an extra field from a data source

Same issue. How do show the new column which I just created in the data source (Excel table, new column added but not shown in Power Bi desktop data field)? somehow I cant do those steps suggested above. thanks 

Highlighted
LouisT Frequent Visitor
Frequent Visitor

Re: Add an extra field from a data source

Sorry, Pand.   the solution I described was the only one i was able to figure out.  Let me know if you find another way.

Rodion Frequent Visitor
Frequent Visitor

Re: Add an extra field from a data source

Thanks, this is by for the most simple solution. It also helps me to understand how to work with M query and the advanced editor, which is a big plus I you're new to this.

LouisT Frequent Visitor
Frequent Visitor

Re: Add an extra field from a data source

Rodion, Glad it worked for you too!  🙂

Benegade Frequent Visitor
Frequent Visitor

Re: Add an extra field from a data source

I had the same issue - with Excel tables I couldn't perform the steps mentioned here as they apply only to CSV files.

 

I found a workaround for Excel files/tables that seems to work for me, so thought I'd share it.

 

I found that I had to save a copy of the existing file e.g. save as Filename_1 or similar, then go data source settings, change data source and select the new file. The new columns then appear.

 

You could then go back and save as the original file name, and change data source back to that again to retain the existing file.

 

Hope that helps.

 

Ben

AlexanderZ Frequent Visitor
Frequent Visitor

Re: Add an extra field from a data source

I have data in a flat azure table with 80 columns. When I getting this data to power bi it analyze only 1000 first rows and automatically creates fields. The problem is that first 1000 columns contain just 25 collumns and bi automaticaly creates not full structure. How I can manualy set data scheme and specify all fields manually?

Thx!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)