Forum

Hi Julien, try the attached solution, should work with variable columns too.

Should be there, update Power BI if you don't see that option. See image attached.

Hi Charles, Only a visual basic based solution can help, or Power Query. Attached is a power query solution, the query I used is: let Sou...

Hi Martin, You have an example here using a custom header to pass the api key. (Set Custom HTTP header ‘X-API-KEY‘ with your Detrack API key inste...

Hi, Depends on the way authentication is designed on each site. Some sites require simple authentication with username and pass provided in bina...

Hi, When you import data from a folder,you should avoid the automatic Combine command. Instead, choose Transform data, and add a new column with...

Hi Sam, You can take a look at these posts, they are useful: And: Without buffering, all of the rows would stream through to Excel and only use...

Hi Junko, The green table from Sheet3 is the Output table, produced by the query. The source table, as written in the query: = Excel.CurrentWork...

Hi Junko, Why would you replace null? Is there a reason? Nulls are not visible in the output table, they show as blanks, but in PQ Editor, if in...

Damir H said Привет. Помогите составить таблицу START, таблицу на листе FINISH. К сожалению, я не знаю английский. Я говорю по-русски) Спасибо за ...

I think you're making things more complicated than it needs to be. When you add a query, a connection will be also added. If you run the code again...

There is another way to import data from PDF. Recently, Power BI Team added this functionality to Power BI, you can import data from PDF files just as...

You can select the table, then in the table tools in ribbon, Design Tab, uncheck the Header Row and move up the cell with the value.

Colin Coles said No. That doesn't work either. I bet you did not tried a clean reinstall 🙂 That should solve any problems. See this article, ...

Hi Colin, Try to Repair your office installation. If this still does not fix the problem, try a clean office re-installation.